Converting a Text file to Excel Spreadsheet

[ExcelUser]

Without going thru the Wizard, is there any way to covert
a text file into an excel spreadsheet (just executing
an .exe or .bat file)? We have a requirement to automate
the conversion of text file into excel with some
predifined formating. Thanks for help.

 

[Dave Peterson]

How about recording a macro when you do it once.

If the name of the text file doesn't change, you could put your macro in a
general module and call it auto_open.

Then when you start that workbook in excel, the auto_open will run and import
(and reformat???) that text file.

You could even have the macro save the converted text file (keep recording while
you're doing it).

If you didn't want it quite so automatic, name the macro something else and use
Tools|macro|macros... and run it on demand (after you load the workbook with the
macro.)