Can you post your current macro?
It should just be a question of running that in a loop...

--
Tim Williams
Palo Alto, CA


"Excel Macros" <Excel wrote in message ...
I have a large number of excel files and I want to use a macro to upload the
data from these files into another excel spreadsheet. The macro that I
currently use requires that I upload these files one at a time. The number of
files is so large that this is too time consuming.