Hi Brent

See this page
http://www.rondebruin.nl/copy3.htm

--

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


"Brent" wrote in message ...
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