Hi Richard
I have a few examples here that you can use maybe
http://www.rondebruin.nl/ado.htm
See also the links on the page to other useful pages
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Richard" wrote in message ...
My OS is MS XP.
Using Excel 2000
I am using XLM GetValue to extract data from Excel Files. I need the path
and file name to the files. Problem is the file names and number of files
change each month. I need to pass the Path and file names to GetValue
without knowing B/4 hand the name or number of files. The files all reside
in one folder.
Thanks in advanced.
--
Richard