save new data to a closed sheet

[nakul2617]

Hi,
I would like to know if i can automatically save my new data to a sheet which is closed.
I want to do it w/o opening that sheet via macro.
Please let me know if it is possible & if possible, give me coding.

Thanks

[arlu1201]

You can ask the macro to open the file, copy the data, save and close it.

But without completely opening it, the data transfer cant happen.

[HaHoBe]

Hi, nakul2617,

no sheet can be closed as this is a feature of a workbook (so a sheet can´t be opened but made visible and be activated when it was hidden).

Using ADO you can transfer the contents to a workbook/worksheet but that may overwrite all the contents in the given worksheet (workbook needs not to be opened for that process).

Ciao,
Holger