Importing TXT file with Macro displays dialog, how to stop?
Posted by Chris on August 03, 2000 8:02 AM
I am importing a text file that is not .TXT and Excel displays a message on the screen stating non-recognizable format. It imports fine. But I do not want this message displayed.
Question 1) How do I stop the dialog. I have applicaiton.screenupdating=false already.
question 2) I copy and paste between two sheets and get a clipboard message about retaining the memory in the clipboard. How do I stop this also ?