The snippet of code below is giving me fits.
I have a couple of input boxes putting in the variable name and the Stub1 is the path and the name of the file.
It is throwing an error when I point to the network.
"Run-time error '1004':
Method 'OpenText' of Object 'Workbooks' failed.