VBScript – How to make program wait until process has finished?

by

You need to tell the run to wait until the process is finished. Something like:

const DontWaitUntilFinished = false, ShowWindow = 1, DontShowWindow = 0, WaitUntilFinished = true
set oShell = WScript.CreateObject("WScript.Shell")
command = "cmd /c C:\windows\system32\wscript.exe <path>\myScript.vbs " & args
oShell.Run command, DontShowWindow, WaitUntilFinished

In the script itself, start Excel like so. While debugging start visible:

File = "c:\test\myfile.xls"
oShell.run """C:\Program Files\Microsoft Office\Office14\EXCEL.EXE"" " & File, 1, true

More Related Contents:

  1. VBA – How to grab the cell below if a cell has text?
  2. Getting ScriptControl to work with Excel 2010 x64
  3. Pop up the Excel Statusbar?
  4. Get list of Excel files in a folder using VBA [duplicate]
  5. VBA : save a file with UTF-8 without BOM
  6. When one should use Set [e.g for SpecialCells return value]?
  7. Should I turn .CutCopyMode back on before exiting my sub procedure?
  8. Determine if cell contains data validation
  9. Sheet protection: UserInterFaceOnly gone
  10. How to highlight a cell using the hex color value within the cell?
  11. Removing special characters VBA Excel
  12. Open an Excel file from SharePoint site
  13. VBA recognizing workbook by partial name
  14. Excel VBA wildcard search
  15. How do I loop an excel 2010 table by using his name & column reference?
  16. Excel VBA Project has generated multiple Workbook objects
  17. Copy an entire worksheet to a new worksheet in Excel 2010
  18. Loop through files in a folder using VBA?
  19. filter out multiple criteria using excel vba
  20. How can Excel VBA open file using default application
  21. Run same excel macro on multiple excel files
  22. Saving a Excel File into .txt format without quotes
  23. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  24. VBA – Range to jpg picture
  25. How to break long string to multiple lines
  26. Can Advanced Filter criteria be in the VBA rather than a range?
  27. In Excel VBA, what is the way to check if the web page is fully loaded?
  28. Excel Useform: How to hide application but have icon in the taskbar
  29. Reading Web Pages using Excel VBA
  30. How do I get a list of unique values from a range in Excel VBA?

Leave a Comment