Copy cells to closed spreadsheet

[gersemale]

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

[Bob Phillips]

Could be done with ADO, but longwinded.

What is the problem with opening?

[gersemale]

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

[ALe]

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:

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