to open .dat file in excel

[Guest]

i have 10 files with .dat extention in a folder if i want to open all such
files with excel amd do automaticaly execute the text-to-columns method... so
that i can plot with the files...

please help me

 

[Pete_UK]

With Excel loaded, do File | Open and navigate to the folder where the
files are - you will need to change the file type to "All files *.*"
to see your .dat files. Then click on one to open it, and Excel will
start the Data Import Wizard automatically. In this you have much more
control over how the data is treated, so you will not need to do Text-
to-Columns (although you could do this if you prefer).

If you need to do it 10 times, then you can record a macro before you
do it the first time, and then re-run the macro subsequently. You may
need to edit the macro so that it does not aways bring the same file
in for each run.

Hope this helps.

Pete