hi all

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a file similar to csv but my extention is res where data will be there
in coloumns and rows.

i want to have a macro which can open that file in excel and automatically
run the text import wizard so that mydata will became cell data for the
opened exel file.

nut shell i need to open some txt file in excel and run text to columns
wizard...

is there any shortcut or macro there?

please help me in this regard
 
You can do that by Open With menu in Windows explorer choose Microsoft Office
Excel to open that file then check Alway use the selected program.....
 

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

Forcing Excel to Import .CSV data 2
Which Excel event to call when opening a .txt file 1
Run-time error ‘13’ mismatch type 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Best Practice - Transfer Data 2
Problems with CSV file input 5
Opening a .csv file thru a macro 3
Can I start the text import wizard automatically? 4

Back
Top