| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate Workbook in Separate Excel Session
I've got some code that plus data from another workbook. It works when the files are in the same instance of Excel; however, if I have the file open in an different instance of Excel the macro doesn't find the specified range. Is it possible to activate this workbook without opening it in the current session of Excel. My code is below: thank ahead of time
If MsgBox("Have you saved BigFile as test1.xls and is that file open?", vbYesNo + vbCritical, "WARNING!") = vbYes The Range(Cells(iRow, 1), Cells(jRow, 12)).ClearContent Windows("test1.xls").Activate |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Startup and template locations in Citrix TS session and local session | Setting up and Configuration of Excel | |||
| Retrieve data from separate Excel session | Charts and Charting in Excel | |||
| Activate Workbook | Excel Discussion (Misc queries) | |||
| Workbook.activate | Excel Discussion (Misc queries) | |||
| excel 2000 workbook.activate not 100% reliable with alt+tab | Excel Programming | |||
Threaded Mode
