Automate the Text Import Wizard (Fixed Width)

[Yagnesh]

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]

Yag

Suggest recording a macro while importing the text file.

Assign the macro to a button or shortcut key combo.


Gord Dibben Excel MVP

 

[Yagnesh]

Gord Dibben,

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

Anything else up your sleeve

 

[Guest]

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.

 

[MrShorty]

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

 

[Guest]

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