error 1004 using variable as a filename in opentext

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.

As I have troubleshot the problem, it appears to be an issue with reading a value into a program from a txt or xlsx file. The Workbook.OpenText will not work when I read the value using Cells() or Range(), and then put that variable in as the filename.

When I hardcode the filename or declare it in the code, the Workbook.OpenText will work.

Any thoughts as to why it won't read in the value from a txt/xlsx file? Any ideas how to solve it?