Yes i am trying to avoid opening it, and thought ADO or DAo would do the job
as oppposed to copy etc but guess i will have to go downt that route then
--
with kind regards

Spike


"Barb Reinhardt" wrote:

The workbook may be closed to begin with, but I suspect you'll have to open
it to import and save your date. That can be done programmatically. Is
that what you mean?

"Spike" wrote:

Is it possible to export data from the active workbook to a closed Excel
workbook. I would like to do this monthly to a different sheet each time. I
know to import data the range has to be named so i assume it is the same
priciple.

If this is possible i would greatly appreciate the relevant code

--
with kind regards

Spike