Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autoformat a .csv file
You'll need a macro that does the formatting.
But .csv files are plain old text files that don't contain macros. You could create a second workbook that opens that .csv file and formats it the way you want, though. Then the user (you?) would open that second workbook to run the macro that imports the data and formats it the way you want. You can get pretty serviceable code by recording a macro when you do it manually. JayKon wrote: I have an application that creates a .csv file and calls EXCELL.EXE with that file as an argument. I would like to have EXCEL autoformat it before displaying it. The idea is to provide a desktop icon that a user clicks to get the current data. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving .csv formated file | Excel Discussion (Misc queries) | |||
Export EXCEL spreadsheet to .csv file | Excel Discussion (Misc queries) | |||
File A and File B Together | Excel Discussion (Misc queries) | |||
.csv drops "0" when saved, even if file was set as "text". | Excel Discussion (Misc queries) | |||
.CSV File into .XLS file | Excel Discussion (Misc queries) |