In later versions of VBA proper syntax is more critical. In VBA Help:
"To iterate over all files in a folder, specify an empty string: Dir("")
Hope this helps. /b[/quote]Good to know. Still stuck in the '90s here, so once (if) we upgrade, I'll have to keep that in mind.
Thank for the input. The problem was that as I was testing the process, the object will not always close properly...it self corrected as my testing span across the whole process versus selected stages. It is working fine in production.
The Dir() is working with application, but I will test the Dir("") version of the code.
I am running Windows 2000 with sp 4 and when I changed the Dir() to Dir("") in my Excel 2000 macros, it started to look for a file in "My Documents" folder , not the directory where I was searching. :confused: No matter how many times I stepped thru it, it stayed on the same file name - never changed file names.