hi all

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
 
G

Guest

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

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

Top