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?
Bookmarks