John,
That's sound advice from Bob, (I'm not even recommending it) but if you
really do not want to open the workbook for some reason, that's about the
only route to go.

Nick

"Bob Phillips" wrote in message
...
John,

Be aware that this is not trivial, will take a degree of learning re ADO,
good workbook design, and a fair amount of code.

IMO it would be simpler just to open the workbook, do your stuff, and
close
it. Pragmatism v knowledge, the choice is yours.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"John" wrote in message
...
Thanks for the reply Nick but I'm not sure what ADO is, I've looked it
up
under Functions but can't seem to find it


"Nick Cranham" wrote in message
...
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