vbscript, Launch Excel & open existing WB

Launch Excel & open existing WB

Author	Message
Dian #1 / 4	Launch Excel & open existing WB I'd like to make a link from my web page that would launch Excel and open an existing file in Excel (rather than opening it within the browser). KB Article 198703 gives the code, but opens a new instance of an Excel spreadsheet and, not knowing the code, I don't know how to modify "set wb=app.workbooks.add" into something that would open an existing workbook. Thanks.
Sun, 13 Nov 2005 01:12:39 GMT

peterDave #2 / 4	Launch Excel & open existing WB Diane, Here's a test vbs file I've created to open an existsing Excel file, add the current date then save and close the file. I run this from the command line. cheers peterDavey Quote: > I'd like to make a link from my web page that would launch > Excel and open an existing file in Excel (rather than > opening it within the browser). KB Article 198703 gives > the code, but opens a new instance of an Excel spreadsheet > and, not knowing the code, I don't know how to modify "set > wb=app.workbooks.add" into something that would open an > existing workbook. Thanks.
Sun, 13 Nov 2005 06:39:10 GMT

dmkit #3 / 4	Launch Excel & open existing WB I'm sorry, but I don't see the test file you sent or attached. How do I get it? Thanks. * Sent via Developersdex http://www.developersdex.com * Don't just participate in USENET...get rewarded for it!
Sun, 13 Nov 2005 11:58:54 GMT

peterDave #4 / 4	Launch Excel & open existing WB Diane, Sorry, I was sure I'd pasted it in. Here it is: '--------------------------------------------------------------------------- --- ' test VB script set WshShell = Wscript.CreateObject("WScript.Shell") set XlObj = CReateObject("Excel.Application") set wkb = XlObj.workbooks.open("D:\Other\IT-Stuff\TestFiles\Test1.xls") wkb.worksheets(1).Range("A2").value = date ' put date in cell A2 wkb.close True ' close and save set WshShell = Nothing set XlObj = Nothing set wkb = Nothing '--------------------------------------------------------------------------- --- It opens a test workbook and enters the current date into a cell. The workbook has a Workbook_Open sub that refreshes a data query that extracts records from an external database using the date as a parameter. It works well. cheers peterDavey Quote: > I'm sorry, but I don't see the test file you sent or attached. How do I > get it? Thanks. > * Sent via Developersdex http://www.developersdex.com * > Don't just participate in USENET...get rewarded for it!
Mon, 14 Nov 2005 06:55:33 GMT

Page 1 of 1

[ 4 post ]