Quote Originally Posted by snb View Post
I can't see which folder you picked.
But try:

        with getobject(replace(c00 & c01,"\\","\"))
You can check the values of c00 and c01 using

Msgbox c00 & c01
Hi, the values did return the name of the files to pick up the data, but this time round is with run time error -2147221020 (800401e4): Automation error Invalid syntax.