Importing Several Files with a Macro

[lyonder2000]

I have a report designed in Access. I have six tables that populate this report. The data for each table comes from six separate excel files. I have designed a macro that uses the TransferSpreadsheet to import the excel files. I wanted it as automated as possible. Here lies my problem. The file name that the Macro requires would have to be changed daily for each of the six files to be found. The files are named the same daily but stored according to date. So if it would prompt me for the date, I could enter "9/23/2008" and my hopes would be for it to import all six files because all six files would be in that "9/23/2008" folder.

Is this possible with the Macro?

 

[PHV]

Use VBA instead of a macro.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886