We have AS400 which outputs a report to a csv daily.
Now you open the csv spreadhseet and the data is right, but the format is
wrong.
Column A too short, Column B needs to be numberic (so we can use a comma in
the 100's), Column C is to short, etc..
We open this daily, do all that formatting just to make it look right. Is
there a way to make a Macro stay in a csv? Any other suggestions? I want to
make this automated if possible.