Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multi-file open to one workbook
I believe there is a shortcut method for opening/copying
several seperate excel files into one workbook, but I don't recall the trick. There are 40+ files which I would like to copy into one workbook with each file's info on it's own sheet within the new workbook. If anyone knows the trick or knows where I can find it on the web, I'd appreciate them sharing their info. Thanks in advance, Drabbacs |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multi-file open to one workbook
There isn't any trick that I am aware of.
you would loop through the list of files open each, copy the sheets to the master workbook close the file. -- Regards, Tom Ogilvy "drabbacs" wrote in message ... I believe there is a shortcut method for opening/copying several seperate excel files into one workbook, but I don't recall the trick. There are 40+ files which I would like to copy into one workbook with each file's info on it's own sheet within the new workbook. If anyone knows the trick or knows where I can find it on the web, I'd appreciate them sharing their info. Thanks in advance, Drabbacs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does a Multi-sheet/user file open on sheet two every time? | Excel Discussion (Misc queries) | |||
Complex Multi-condition, multi-workbook count | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
in excel when I open my workbook the file name is followed | Excel Discussion (Misc queries) | |||
VBA for XL95, Workbook.open non XL-file | Excel Programming |