Opening Excel remotely
I have an Excel file on a network which happens to be on a different machine
than the Excel Application I want to open this file What code would launch the Excel app automatically ( without user intervention) that is on the network as well as then go and open this excel file which is also on the network but in a different location from the Excel App. I thought CreateObject but that doesn't seem to do it Thanks |
Opening Excel remotely
To open the workbook in the existing Excel session:
Application.Workbooks.Open PathName - Or, to start a new Excel session: Dim XLApp As New Excel.Application XLApp.Workbooks.Open PathName XLApp.Visible = True .... Add any additional code here. And, unless you plan on leaving the book open for your user, you should end your code with the following (to close the Excel session and free up the object variable): XLApp.Quit Set XLApp = Nothing K Dales -----Original Message----- I have an Excel file on a network which happens to be on a different machine than the Excel Application I want to open this file What code would launch the Excel app automatically ( without user intervention) that is on the network as well as then go and open this excel file which is also on the network but in a different location from the Excel App. I thought CreateObject but that doesn't seem to do it Thanks . |
All times are GMT +1. The time now is 11:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com