I Apologizes for so many questions.
No problem, how do we learn if we don't ask?
The sPath is the "description" of how to "find" the folder where your files are stored.
To test the macro I put your uploaded file in the "a_tamp" folder on my "D" drive so the sPath is then
and the files that should be tested are all the ".xlsx" files in that folder so you add the "wild card" "*" in order to get all files with the ".xlsx" extension so sFile becomes
So if you put the test file (remember at the moment macro only work for 1 file) in "User\Lab\Desktop" folder on the "C" drive your sPath is then
And the last "\" is most important as the macro will not work if it's missing!
The sFile to find the file is then
Hope this makes things a bit more easy to understand.
Alf
Bookmarks