Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Mala
  • Order by date
  1. Mala

    How do I Iinterpolate from a data table? EXCEL

    A similar problem was dealt with long ago in: http://eng-tips.com/viewthread.cfm?qid=4962 Mala Singh 'Dare to Imagine'
  2. Mala

    Magnificent VBA Writers

    Hi rnordquest I have set up a file to do what you wish to. This is how it will work: 1. Clear any data from previous runs 2. Paste your lines of data starting from range A1 3. Click the 'Run' button Tha macro will parse the data and put the equation corresponding to each line of data in column...
  3. Mala

    Visual Basic with Autocad

    That's right - the AutoCAD online help documentation is the best possible source of information. Mala Singh 'Dare to Imagine'
  4. Mala

    How to combine 4 Exel files in to 1 Exel file with 4 sheets?

    Kris, The code I wrote was in Excel VBA - for which the Excel objects like Workbook, Worksheet etc are native. When using the code from any other VB/VBA environment you need to set reference to the Excel object library and declare the variables as johnwm has suggested. Mala Singh 'Dare to...
  5. Mala

    Formula for Open Channel Flow in Circular Pipe

    I do not think you need to learn VBA to be able to do this. It is enough to set up the worksheet with an input area comprising the input variables (pipe dia, liquid level etc) and an output area which will contain formulas (for theta, wetted area etc). The formulas in the output section would...
  6. Mala

    Simple Question on VBA AutoCAD arrays.

    Thanks for the update. Fortunately, the meaning is not half as bad as I had imagined... [smile] Mala Singh 'Dare to Imagine'
  7. Mala

    Simple Question on VBA AutoCAD arrays.

    LumpoDelMagnifico, I am not good at languages other than English - but I suspect 'LumpoDelMagnifico' is Spanish? Can you translate this for me? I just want to verify if it really means what I suspect it is meant to mean...I am not divulging my guess lest someone red-flags this post!! Mala...
  8. Mala

    Simple Question on VBA AutoCAD arrays.

    Sorry, forgot another item - why use a function to which an array needs to be passed? why not just place the two lines of code (in the function) in the original (calling) point... Mala Singh 'Dare to Imagine'
  9. Mala

    Simple Question on VBA AutoCAD arrays.

    You cannot ReDim Preserve an array without initially declaring it with a Dim statement. Also your function indicates that the array is initialized elsewhere - the point which is calling the function. At this point you need to declare the array with a Dim statement - e.g. Dim MyArray(). After...
  10. Mala

    Open a new drawing from within Autocad

    You need to use code like: Sub OpenFiles() Dim CurrentDwg As AcadDocument Dirname = "C:\Documents and Settings\Mala Singh\My Documents\" Dim DwgNames(1 To 10) DwgNames(1) = "Dwg1" DwgNames(2) = "Dwg2" DwgNames(3) = "Dwg3" DwgNames(4) = "Dwg4" DwgNames(5) = "Dwg5"...
  11. Mala

    How to ref. the AutoCad object of a specific version if u have 2 w/ VB

    Use version-dependent ProgIDs. For example, if you are using CreateObject, instead of : CreateObject ("AutoCAD.Application"), use CreateObject ("AutoCAD.Application.16") for AutoCad2004. For AutoCAD 2002, use CreateObject ("AutoCAD.Application.15"). Mala Singh 'Dare to Imagine'
  12. Mala

    Stringing together with IF()

    Yes, a user defined function would be much cleaner. Added advantage: You would not have to type such a long formula everytime. You could use the following code Function JoinCells(cell1 As Range, ParamArray Addr()) As String JoinCells = cell1.Text If Len(JoinCells) > 0 Then JoinCells =...
  13. Mala

    Stringing together with IF()

    Almost like chatting on the forum. :) Mala Singh 'Dare to Imagine'
  14. Mala

    Stringing together with IF()

    You can concatenate up to 30 cells (I do not think yu will need to do it for more). If you need the result to show the cell values separated with underscores, the following would be a better way...
  15. Mala

    Stringing together with IF()

    Try using the formula: =CONCATENATE(C10,D10,E10,F10,G10) Mala Singh 'Dare to Imagine'
  16. Mala

    Turning off 'help'

    BTW F2 nmormally controls the state of the ACad text window - F1 opens Help. Mala Singh 'Dare to Imagine'
  17. Mala

    Turning off 'help'

    Try disabling the F2 key by editing the Accelerators section of the menu file that loaded in your ACad session. Look at the topic: 'menu files, editing' in the ACad Help. Mala Singh 'Dare to Imagine'
  18. Mala

    Choose Table then lookup values

    It should be quite possible to do this. Please explain a bit more how the tables are laid out and how the two numbers you input identify which table to use. Is it that one of the cells contains the table number and the other the value to be lookd up? Mala Singh 'Dare to Imagine'
  19. Mala

    Cannot open XLS in Excel 97 (Device I/O Error)

    It is unlikely that err checking would repair the file. analogkid2digitalman is dead right when he says, 'back up, and back up often!' Fortunately, Excel provides a way to do so without having to repeatedly create a backup manually.... It is a good idea to save an file with the backup option...
  20. Mala

    Cannot open XLS in Excel 97 (Device I/O Error)

    I/O error usually implies that your file is irrecoverably corrupt. I am afraid there's no way around this except to recreate your workbook - I say this coz I have encountered this situation occasionally and have not been able to find any other way... Suggestion: Use the most recent 'good' copy...

Part and Inventory Search

Back
Top