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