
Originally Posted by
Paul
Just checking, but does your fPath end with "\"? If not, then you might be trying to open something like:
"F:\Data\AllPMapTogether\AllExportTopZeroTable.xlsx"
instead of
"F:\Data\AllPMapTogether\AllExport\TopZeroTable.xlsx"
Yes, my path has the quote included with it. I have also tried to omit the "\" and add it by:
Workbooks.OpenText Filename:=fpath & "\" & fname,...
but neither solved the error.
Bookmarks