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
.
|