Run-time error '1004' for .Refresh BackgroundQuery:=False for loop

Good Afternoon All,

I recently received help on a macro I am creating to run a loop through all files in a set folder. (seen here:
http://www.excelforum.com/excel-prog...ml#post3471431)
A very helpful member has assisted me in my journey of completing said task but I am faced with an error of "Run-time error '1004': Excel cannot find the text file to refresh this external data range" and then proceeds to end up at the line:
.Refresh BackgroundQuery:=False

Its not producing an output file for the first one before looping through and I cannot figure out how to resolve the error.
Any suggestions or reference material would be greatly appreciated!

Please Login or Register  to view this content.

Thanks for the reply noboffineme. I think in line 3 of the code is where I have a path set.
Input_File = Dir("C:\Path\*.pch")