Saving import format 1

[RamziSaab]

I have txt files that need to be imported to excel they are always in the same format, however is there a way to save where the fixed columns are in the txt import wizard so i can run a macro to import and format teh files automatically.

Hope my question is clear?

thanks

 

[RamziSaab]

I guess to make it clear it there a way to specify the fixed width when importing using vba

 

[Dsuperc]

The simplest way is to open an blank excel spreadsheet, then start recording a macro. Open the text file, follow the wizard, and then end macro. The only problem here is the name and location of the text file.

 

[RamziSaab]

Should have thought of that...thanks can modify the macro to ask user to input file name!

 

[DrSimon]

If the text files are produced with the same names, the best way to approach import is to use schema.ini files. Come back here if you need more info.