Start new app (vbs)

Topic

New Reply

Hi. I want to create a script (.vbs) file to run Excel and open a specific workbook. I thought I could just add a line such as:
C:Program Files… Excel.Exe C:Some Folderbook1.xls
Will this work, or do I need to use the Shell function to cause this to happen? Thanks, Andy.

Reply | Quote

Replies

Try this:

Dim xl
Set xl = CreateObject(“Excel.Application”)
xl.Visible = True
xl.Workbooks.Open “C:Some Folderbook1.xls”

Reply | Quote

Just the job. Thanks. Andy.

Reply | Quote