Open workbook in existing Excel session
How are you opening the workbook now? Are you instantiating an instance
of Excel?
The workbook will open in the same instance by default, you'd have to
explicitly tell it to open in a new instance.
Example
Workbooks.Open Filename:= _
"C:\Documents and Settings\yadayada.xls"
|