How to use GetObject in VBScript

by

VBScript GetObject documentation can be found here. Here is a VBScript sample:

Set objExcelFile = GetObject("C:\Scripts\Test.xls")
WScript.Echo objExcelFile.Name
objExcelFile.Close

This code will get you the Excel Workbook object contained in C:\Scripts\Test.xls. You can use TypeName() to confirm that:

Set objExcelFile = GetObject("C:\Scripts\Test.xls")
WScript.Echo objExcelFile.Name
WScript.Echo TypeName(objExcelFile)
objExcelFile.Close

The output will be:

test.xls
Workbook

If the specified Excel workbook doesn’t exist the script will return an error. If an instance of Excel is already running you can use this code to get a reference to it:

Set objExcel = GetObject( , "Excel.Application")

For Each objWorkbook In objExcel.Workbooks
    WScript.Echo objWorkbook.Name
Next

objExcel.Quit

Notice the comma before ‘Excel.Application’. The script gets a reference to a running Excel application, lists open workbooks names and quits Excel. If there is no Excel instance running you will receive an error. This is also why you couldn’t use GetObject() to get an instance of Scripting.FileSystemObject – there was no running instance.

You could use GetObject if there is an instance og Scripting.FileSystemObject already running in memory. Try this code:

Set objFso = CreateObject("Scripting.FileSystemObject")
Set objFso1 = GetObject("", "Scripting.FileSystemObject")

WScript.Echo TypeName(objFso)
WScript.Echo TypeName(objFso1)

You can see that you first need to use CreateObject() to and when FileSystemObject is running it is possible to get a reference to it, but this doesn’t make much sense because you already have a reference to it (objFso). So, use CreateObject() to create an instance of FileSystemObject.

More Related Contents:

  1. Is it possible to embed and execute VBScript within a batch file without using a temporary file?
  2. Adding quotes to a string in VBScript
  3. Recursively access subfolder files inside a folder
  4. Hide command prompt window when using Exec()
  5. Cannot use parentheses when calling a Sub Error 800A0414 VBS
  6. Prevent VBscript app from showing Console Window
  7. Read and write into a file using VBScript
  8. Creating multi-select list box in VBScript [closed]
  9. Does VBScript allow named arguments in function calls?
  10. How do I sort arrays using vbscript?
  11. VBscript code to capture stdout, without showing console window
  12. Access network share from within VBScript eg FileSystemObject
  13. Breaking a String Across Multiple Lines
  14. ADODB.Parameters error ‘800a0e7c’ Parameter object is improperly defined. Inconsistent or incomplete information was provided
  15. What does the “On Error Resume Next” statement do?
  16. Find my own process ID in VBScript
  17. How to find the window Title of Active(foreground) window using Window Script Host
  18. How to identify between ok and cancel button in inputbox
  19. Passing-variable-from-vbscript-to-batch-file with arguments
  20. Can I pick up environment variables in vbscript WSH script?
  21. VBscript relative path
  22. Use clipboard from VBScript
  23. How do I include a common file in VBScript (similar to C #include)?
  24. Vbscript list all PDF files in folder and subfolders
  25. VBS with Space in File Path
  26. Can not send mail using smtp.gmail.com, port 587 from vbs script
  27. Creating and writing lines to a file
  28. How can I use the common Save As dialog from VBScript?
  29. Create a folder in Outlook: error 800A0401 – Expected End of Statement
  30. Run a vbscript from another vbscript

Leave a Comment