ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   open Excel workbook using vbscript (https://www.excelbanter.com/excel-programming/277176-re-open-excel-workbook-using-vbscript.html)

Tom Ogilvy

open Excel workbook using vbscript
 
In your script, include a line of code like:

Workbooks.Open "C:\my folder\myworkbook.xls"


Hopefully you don't mean the script is contained in that workbook.

--
Regards,
Tom Ogilvy


"fern" wrote in message
...
Hi there,

how to write a vbscript so that when the script run, my
Excel workbook will automatically open?


thanks in advance.





All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com