View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
kkknie[_6_] kkknie[_6_] is offline
external usenet poster
 
Posts: 1
Default Running .BAT file from within a macro...

Use:

Shell ("C:\BatFile.bat")

You may need to wait a few moments to let it complete. Something
like:

Dim datWait as Date

datWait = Now() + 3/24/60/60

Do Until Now() datWait
Loop


K


---
Message posted from http://www.ExcelForum.com/