John,
If you use ADO (and what you want to do is suitable for this), the workbook
is not opened in the same sense as Excel automation.

NickHK

"John" wrote in message
...
I have a Macro that copies data to another Workbook. Is it possible to
execute this code without having to actually open up the second Workbook??

Thanks