You should be able to get all the code for this by doing the operation
manually with the macro recorder turned on.

HTH,
Shockley


"BryanL" wrote in message
...
I am importing text files into excel automatically, but
after the first time I do it, I don't want the data to
update again. The excel file is opened automatically
using a macro, so I tried to use a macro to turn it off,
but could not find anything that effected it. Does anyone
have any idea's on how I can do this?