Cannot Find Text File to Refresh (QueryTable & OS X)

I am new to VBA in Excel. I have been going through the forums to figure out how to load multiple text files into multiple worksheets. Using Excel 2011 - v14.2.3 on OS X 10.8 - Mountain Lion.

I am having trouble with what I assume is the file referencing. When I run the attached macro, I get an error stating it cannot find the text file. If I remove the ".Refresh" line it will process through and create the right number of new blank worksheets. I know the fpath codes for the Dir function, but I do not know if it will work with the QueryTable connection string. (I also tried to use fpath2 in the connection string but that did not work either).

Any pointers would be greatly appreciated.

Please Login or Register  to view this content.