Importing to Excel file from .txt format

  • Thread starter Thread starter Sobhan
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to import Text file to Excel 3
Importing .txt data into Excel 1
Import Several .txt Files 2
Import txt file into excel with 281,344 rows 2
Importing a space-delimited txt. file right-justified into Excel 2
Import Txt file over several excel sheets 2
Saving as txt file 2
Formatting .txt File 1

Back
Top