Importing to Excel file from .txt format

S

Sobhan

Hi all,
I want to write a automated program so that when i give .exe
name at command line it should read/search for(specific pattern from
the .txt file(in a specific directory) in .csv format and import to
excel file in tabular format.Can anybody help?

Regards
Bubunia
 
N

Nikos Yannacopoulos

Why an executable and command line and blah-blah-blah, when you can use
Excel's built-in VBA to do the job? Just record a macro while you are
opening a text file in Excel, and you'll get most of the code!

HTH,
Nikos
 
Top