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
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?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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:
"='" & YourFolderPath(with \ at the end) & "[" & NameOfFile.xls & "]" & YourSheetName & "'!" & YourRangeAddress