Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to open .dat file in excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
to open .dat file in excel
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 On Sep 28, 12:51 pm, Ramki wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When i open excel file it takes time to open | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel |