M
mcphc
I have a VBA macro that uses two different excel files (workbooks) that are
open in one session of excel.
This works fine if each file is opened within one excel program. ie open
excel and then open both files via file->open within the one excel session.
If I open only one of the files in excel and then open another excel session
by clicking Start->Programs->Microsoft Office->Microsoft Offic Excel and then
use this excel session to open the other file the VBA will not run as it can
only see one of the files (workbooks).
Is there a way for excel to run a VBA between two different excel sessions?
Even if I could have the program use CopyAs to copy the workbook from one
excel session to the other.
Thanks
open in one session of excel.
This works fine if each file is opened within one excel program. ie open
excel and then open both files via file->open within the one excel session.
If I open only one of the files in excel and then open another excel session
by clicking Start->Programs->Microsoft Office->Microsoft Offic Excel and then
use this excel session to open the other file the VBA will not run as it can
only see one of the files (workbooks).
Is there a way for excel to run a VBA between two different excel sessions?
Even if I could have the program use CopyAs to copy the workbook from one
excel session to the other.
Thanks