Help! When I execute a procedure to import a text file
into Excel, the Design Mode is automatically engaging,
which then doesn't allow the procedure to process any
further actions past the open text file. How do I stop
this?

Never heard of anything like that.

Perhaps you should show the code around the spot where you think this is
happening. How do you know you are in design mode?

--
Regards,
Tom Ogilvy

"Melissa Matile" wrote in message
...
Help! When I execute a procedure to import a text file
into Excel, the Design Mode is automatically engaging,
which then doesn't allow the procedure to process any
further actions past the open text file. How do I stop
this?

The procedure is simple. One line:
Workbooks.OpenText "c:\class\JuneData.txt"

If the procedure is triggered by a keyboard shortcut, then
Design Mode is activated (you can tell by the button on
either the VB toolbar or the Control Toolbox).

If the procedure is triggered by clicking Run in the Run
Macro dialog box, then Design Mode is not activated.

It's insane and I can't figure out what the problem is.

mmm

-----Original Message-----
Never heard of anything like that.

Perhaps you should show the code around the spot where
you think this is
happening. How do you know you are in design mode?

--
Regards,
Tom Ogilvy

"Melissa Matile"
wrote in message
...
Help! When I execute a procedure to import a text file
into Excel, the Design Mode is automatically engaging,
which then doesn't allow the procedure to process any
further actions past the open text file. How do I stop
this?


.