View Full Version : [SOLVED:] Copy cells to closed spreadsheet
gersemale
08-29-2005, 06:52 AM
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
08-29-2005, 07:09 AM
Could be done with ADO, but longwinded.
What is the problem with opening?
gersemale
08-29-2005, 07:52 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.