I have some text files which I want to open in Excel. I use the Text
Import Wizard and it works with no problems. As I am going to be doing
this a lot, I want to write a macro so I can do it at the press of a
button.

However, when I try to record the macro and use the Text Import Wizard,
I get the error message "Too many lines". After OK'ing the error
message, the file is opened properly, but the macro recorder has turned
itself off and when I look at what has been recorded it's all in red -
obviously an error.

Is there a way I can get around this? It's not that there are too many
columns, it's just that there seems to be a limit to the number of
lines that can be recorded in a command in a macro.

Thanks for any help.

free


--
freekrill
------------------------------------------------------------------------
freekrill's Profile: http://www.excelforum.com/member.php...fo&userid=7561
View this thread: http://www.excelforum.com/showthread...hreadid=399371