TroyW,
I finally got it working. The problem was that the macro is in a template
and I was changing the macro in a worksheet created by the template. I
should have been changing the macro in the template. I thought the changes
you make to a macro in a worksheet updates the macro in the template.

Thanks for all your help


John
"TroyW" wrote in message
...
John,

I've tested changing: "TEXT;C:\EMP4\" and it works for me. What is the
exact error message that you are receiving?

Troy

"John Garate" wrote in message
...
Troy,
I'ts when I change the line of code to "TEXT;C:\EMP4\Tab files for
Excel\EM Church Schedule.tab",
that the macro hangs. The only thing Ive done is change EMP3 to EMP4.
I know I could repeat using the MacroRecorder, but this is a diddicult
process because of the query. I was hoping to just to edit the code.

John