Member Avatar for lucameyer

Hi everybody,

I need a little help. I have built a complex ms excel workbook that imports data from many single sheet ms excel workbooks. These workbooks are all located in one directory and are give a 7 digit name (ex. 1234567.xls). Note: the files are actually named by their finished stock code so there will be no pattern to the many file names in the directory. I would like my master workbook to automatically look in the directory and import all the data from from those workbooks. Now heres the problem. New files are created every day. I may be dealing with several hundred by the end of a fiscal quarter.

I tried using the Indirect.exe add-in but it is very slow and i am only testing with 5 files at the moment. it will probably crash if i try to use 300 files as I am planning.

I'm hoping someone has some stock vba code that will work for my situation or can easily point me in the right direction. I would perfer to stay in excel but I am not opposed to importing all files into Access so long as it's automatic and will look to each file for fresh data.

If anyone can help, I would greatly appreciate it.

Thanks in advance,

John

  • 2 Contributors
  • 1 Reply
  • 96 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by baymont
Member Avatar for baymont

If you found a way to do this, please share with me. I am doing the same thing and would greatly appreciate the help as well.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.