Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine multiple Excel documents into one
Howdy Folks,
I often work with laboratory analytical data that comes to me in multiple spreadsheets. Before I bring these data into a database, I combine the separate Excel files by hand into one. Is there a way to accomplish this programatically? Here are some additional details: The Excel files do not have consistent names. If possible, I'd like to be able to specify a directory and combine every Excel file that directory contains. The files all have the same data structure (same number of identically named columns), although the number of records in each Excel file will not be the same. Does anyone have any hints, or any code they'd like to share. I'm a VBA rookie and I'm not sure where to start. Thanks in advance for any help. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I combine 2 excell documents to make one... | Excel Discussion (Misc queries) | |||
Opening multiple documents in Excel | Excel Discussion (Misc queries) | |||
Opening multiple documents in Excel | Excel Discussion (Misc queries) | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
How do I link multiple excel documents? | Excel Discussion (Misc queries) |