Copy cells to closed spreadsheet

Hi,

Just wondering if it is possible to append a range from one open workbook to another closed workbook without opening it? Any tips would be much appreciated.

Thanks,

Ger

Could be done with ADO, but longwinded.

What is the problem with opening?

Not so much a problem with opening it once it wouldn't take too long. How would i got about testings this?

I think that when you open a workbook with links to other workbooks, Excel does exactly what you say. He get values without opening any workbook.

Create a macro that writes the link in a cell in this way:

Code:

---

"='" & YourFolderPath(with \ at the end) & "[" & NameOfFile.xls & "]" & YourSheetName & "'!" & YourRangeAddress

---