Automate the Text Import Wizard (Fixed Width)
 

I have a Text file which I need to bring into Excel using the Text
Import Wizard. I use the Fixed Width option since each column is a
certain characters long.

Is there a way I could automatically save my "breaks" so I'm not
breaking the file every week. Some add-in or a method would be
appreciated.

Thanks
Yag


--
Yagnesh
------------------------------------------------------------------------
Yagnesh's Profile: http://www.excelforum.com/member.php...o&userid=25661
View this thread: http://www.excelforum.com/showthread...hreadid=395843

Yag

Suggest recording a macro while importing the text file.

Assign the macro to a button or shortcut key combo.


Gord Dibben Excel MVP

On Mon, 15 Aug 2005 11:33:42 -0500, Yagnesh
wrote:


I have a Text file which I need to bring into Excel using the Text
Import Wizard. I use the Fixed Width option since each column is a
certain characters long.

Is there a way I could automatically save my "breaks" so I'm not
breaking the file every week. Some add-in or a method would be
appreciated.

Thanks
Yag

Gord Dibben,

Unfortunately, Excel doesn't allow any menus to be used when the text
import wizard is open. So I can't even get to the record a macro
feature.

Anything else up your sleeve?


--
Yagnesh
------------------------------------------------------------------------
Yagnesh's Profile: http://www.excelforum.com/member.php...o&userid=25661
View this thread: http://www.excelforum.com/showthread...hreadid=395843

I thought I could get around the menu bar by using the short cut keys (eg:
Alt+T) But that didn't work. What did work is recording the macro before
accessing the file. To do this you would need to use the same file location
and file name. For instance I created a folder called "EXPORT FILES" and
then saved my file as 1.prt (prt is the previous file extension). Each time
I pulled up a file that I wanted to insert the same breaks I resaved that
file as the name 1.prt. It's an extra step but at least you don't have to
keep putting breaks into each file.


"Yagnesh" wrote:


I have a Text file which I need to bring into Excel using the Text
Import Wizard. I use the Fixed Width option since each column is a
certain characters long.

Is there a way I could automatically save my "breaks" so I'm not
breaking the file every week. Some add-in or a method would be
appreciated.

Thanks
Yag


--
Yagnesh
------------------------------------------------------------------------
Yagnesh's Profile: http://www.excelforum.com/member.php...o&userid=25661
View this thread: http://www.excelforum.com/showthread...hreadid=395843

How are you accessing the text import wizard -- File-open or Data-import
external data? If you haven't tried the Import External Data command, I
would suggest you try it to see if it will help you. This sets up what
Excel calls a "Query Table" which includes saving the settings from the
Text Import Wizard.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=395843

I accessed the wizard from Data/Import External Data/ Import Data

"MrShorty" wrote:


How are you accessing the text import wizard -- File-open or Data-import
external data? If you haven't tried the Import External Data command, I
would suggest you try it to see if it will help you. This sets up what
Excel calls a "Query Table" which includes saving the settings from the
Text Import Wizard.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=395843