Jim, in an effort to help you with Pan X as much as I can, here are some further details. Maybe I can help prevent others from running into this problem.
The code I wrote, which gives the error message, is:
When the above code is activated, the Error Wizard window appears with “fileload(: The file “Portfolio.txt” couldn’t be opened because there is no such file”
Now here is the code the procedure recorder wrote:
importtext arrayrange(lftocr(binarytotext(fileload("/Users/vicdifranco/Data/Financial/Investment Folder/Portfolio.txt"))),2,-1,cr()),“ExistingData”,“Replace”,“AddFields”,“No”,“ReArrange”,""+tab()+import()
The FIRST time I ran this code, the file data was successfully imported into the database and replaced all existing data as it should. Note the fileload parameter is identical to my version. BUT, and this is really weird, when I ran the SAME procedure a second time (and third, and fourth, etc.), an EMPTY Error Wizard window opened. I include a copy of the error window attached below. The macro did import the text data, but the macro was interrupted by the error window with no error shown.
I generally try to solve things myself rather than burden the forum, but this one is too bizarre for me. By the way, the code I wrote (the first one shown above) is successful in other Pan X macros for other database imports of text files. That’s why I was so sure this would work. The other DBs use the exact same code, with only the path and textfile name different, and everything works as expected.