Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a file remotely | Excel Discussion (Misc queries) | |||
Opening Excel file when connected to the system remotely | Excel Discussion (Misc queries) | |||
Protect a range of cells remotely from another file | Excel Discussion (Misc queries) | |||
Excel slow but NOT when connected remotely!! | Excel Discussion (Misc queries) | |||
Editing Spreadsheets Remotely | Excel Discussion (Misc queries) |