View Single Post
  #2 (permalink)  
Old June 28th, 2010, 11:13 PM
jbinarao jbinarao is offline
Authorized User
 
Join Date: May 2010
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Would this work for you? You would not be limited to opening only XLS Files, but also DOC, PDF, TXT, MP3, EXE, etc:
Code:
Dim objShell
Set objShell = WScript.CreateObject("WScript.Shell")

'WScript.Echo "The next line of code runs the file."
objShell.Run "C:\Scripts\New_users.xls", 5, True

'WScript.Echo "The next line of code destroys the object."
Set objShell = Nothing
More details on the Run Method can be found here:
http://msdn.microsoft.com/en-us/libr...ky(VS.85).aspx

Reply With Quote