Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
importing files from a directory
I would like to be able to import the data from every file in a directory.
example c:/testdirectory files in testdirectory file1.xls file2.xls file3.xls i understand how to import a single file manually. I however want to be able to import every file in the directory regardless of the number of xls files? Can you make an import..... "file*.xls" command? i would like to do this in a macro and or when the compiled xls worksheet is opened. the data in each file maybe of variable length. I want the data to be appended to the data already in the file that im importing to. thanks for your help in advance, dr chuck |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing data from mulitple files in a directory | Excel Discussion (Misc queries) | |||
Importing a Word merge directory into Excel | Excel Discussion (Misc queries) | |||
Files in a directory? | Excel Discussion (Misc queries) | |||
Importing a Directory Listing from CD to Excel | Excel Programming | |||
Check if directory empty OR no of files in directory. | Excel Programming |