westconn1 :
when I try that code I get 'expected function or variable at the OpenText statement. I don't understand why.

RobDog888 :
the code compiles but the Excel file is still not parsed right (default settings that are different from those that I specify in the OpenText statement).