Opening Workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am coding using VBA and ADO. Trying to make an automated system that goes
to a folder and opens a file, loads the data needed, and closes the file, one
after the other for all the files in the folder. I want to do this without
referencing the names of any of the workbooks because the names change daily.
Is there any way to do this?? Thank you.

Brent
 
It looks like I would have to enter the names manually into a sheet in the
workbook. I do not want to worry about the names at all, but I still want
the program to go through each file. Thank you.
 
If all workbooks are in a folder you can run the code for all workbooks without knowing the names
There is also a macro to select the files
 
Thank you. That helped.

Brent


Ron de Bruin said:
If all workbooks are in a folder you can run the code for all workbooks without knowing the names
There is also a macro to select the files
Click to expand...
 
Back
Top