Thread: Import data from multiple excel files in one folder
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Import data from multiple excel files in one folder
hi WingZero

Try this example
http://www.rondebruin.nl/summary2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"WingZero" wrote in message ...
I have a set of sequentially numbered files (starting at 1000.xls) in a main
folder that contains subfolders. I want to import data from certain fields,
with a new row for each file. I currently am using:

='P:\Folder 1\Main Folder\subfolder\[1002.xls]POForm1'!$L$1

to link to the data I want, modifying the file number by hand to update the
file. I have 32 different pieces of data that I am pulling from each file,
along with 6200 files and counting.....
Reply With QuoteReply With Quote