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?

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?

When using the macro recorder, it shows opening the file, but does not
show disabling the external data importer. Does anyone know if this is
even possible?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Sorry, I didn't understand your question. Would it work to protect the
workbook after the first refresh?

Regards,
Shockley


"Bryan L" wrote in message
...


When using the macro recorder, it shows opening the file, but does not
show disabling the external data importer. Does anyone know if this is
even possible?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Protecting the workbook stops the data from being imported, which is
what I was looking for; however, it also stops the macro from
completeing, because it asked for user intervention to keep going. Is
there a way to suppress this error message, or another way to stop the
data from being imported?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!