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!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Litalu

  1. Litalu

    Calling non-activex dll from VBScript

    Hello all, I currently have a non-activex dll which I need to access from either vbscript or jscript. Unfortunatley I am not that familiar with this situation. Can anyone help. Regards, Lit.
  2. Litalu

    Usinging VBScript to get Data from Excel

    Thanks for your help but I am still having some issues. Currently the following script works within the excel VisualBasic editor but does not work when I move it into my application that has the VBScript engine in it. Set appexcel = GetObject(, "Excel.Application") Set wsobj =...
  3. Litalu

    Usinging VBScript to get Data from Excel

    Here is the reference that I was talking about: "If you omit the pathname argument but leave the comma Set wordApp = GetObject(, "Word.Application") VBScript returns an existing instance of the Application object if one exists."
  4. Litalu

    Usinging VBScript to get Data from Excel

    According to the information that I have been able to find, the GetObject(, "Excel.Application") is used when the application that you are reference (Excel in this case) is currently running on the machine. The example that you provided earlier would be used in the case where Excel did not...
  5. Litalu

    Usinging VBScript to get Data from Excel

    Here is my script so far: Set appexcel = GetObject(, Excel.Application) Set wks = appexcel.Sheets(1) Var1 = wks.Cells(1, 1) It gives me a ActivX component can't create Object error whenever I tried to execute it. I have the excel workbook open but I can't seem to get it to...
  6. Litalu

    Usinging VBScript to get Data from Excel

    I can see where Getobject might be used but I can't seem to find enough information to properly format the code. I have the path but what do I use for the objecttype assuming that the appname is excel.exe Thanks,
  7. Litalu

    Usinging VBScript to get Data from Excel

    I can see where Getobject might be used but I can't seem to find enough information to properly format the code. I have the path but what do I use for the objecttype assuming that the appname is excel.exe Thanks,
  8. Litalu

    Usinging VBScript to get Data from Excel

    I have searched through the forums but have not been able to find a simple example of how to get a single excel cell into a 3rd party application using VBScript. I have an open excel sheet which has information in a cell that will change periodically. The excel sheet is always open so I need...

Part and Inventory Search

Back
Top