PDA

View Full Version : Solved: text to columns



philfer
12-31-2007, 12:49 PM
I am importing a text file and have recorded a macro to convert text to columns

Everytime I run it it asks me if I want to "replace destinations cells"

How do I avoid this. I tried Application.EnableEvents = False

But the message keeps coming up. Is there a way I can avoid this as I always want to replace the destination cells

mikerickson
12-31-2007, 03:35 PM
You could clear the sheet before importing the new data.

HaHoBe
01-01-2008, 02:20 AM
Hi, philfer,

I wouldn?t exclude the events behind the sheets (unless you forget to mention them) but use Application.DisplayAlerts = False for not displaying any Excel Dialogs at runtime (please turn them on explicitely at the end of the macro by setting the value to True again as the messages will not be displayed automaticly when the macro in ended).

Ciao,
Holger