csv files and macros when sent from as400 iseries

[chipperjonesrules]

we generate a lot of reports from the as400 that are emailed in csv format.
yesterday we were asked to start running macros etc to generate bar graphs and such from these csv files before they are sent out to the user.

we know how to create the csv file, we know how to do the macros in excel, what we do NOT know how to do is to generate this from the csv file without human interaction, without us having to open the csv, run macro, then email it.

what is everyone doing in this circumstance?
is there a way to perform these macros on the CSV file from the iseries without a user having to open them?

 

[itsp1965]

I haven't worked with scripting/macro development in awhile, but why don't you create a VBA script in Excel to retrieve the CSV file from the iSeries or from a disk location where the files are dumped to and proceed to import the CSV, format the report to your liking, generate the bar graph and then have the Excel file mailed to your users instead?