View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
 
Posts: 360
Default 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"