auto formatting csv when loading/open

[tim]

I have a program that creates a csv file and ftp's it to a
user.

the user will (for the most part) double click the
report.csv file to open it in excel.

how do I have excel format the columns and cells?
(I have data that I need to keep leading zeros - 001 ,
excel remove the zeros, I don't want to use '001' or '001
because the ' are not removed and are ugly to look at.
and
Is there a way to save part of the report to a second sheet
(or TAB), the csv file contains two reports and I would
like to have one on one sheet, the second report on
another sheet in the same workbook.

TIA

 

[Dave Peterson]

csv files are plain text--so no formatting (or macros) will travel with them.

But if your files are consistent, you could create a macro that opens the file,
formats the data. You could even have the macro open both files and merge them.

And I'd rename the .csv file to .txt. Have them save the file in the same
folder each time and then your program could become pretty automatic.

I'd start by recording a macro while importing the data and formatting it.

Post back if you have trouble.