I have one application that automatically generate some excel files, refreshing the data according to a parameter(sales person, region, ...). All excel files have the same number of sheets, same columns, same rows, but it does not export the excel files with graphs.
My idea is that I can generate an excel macro (step by step macro) for one of the excel files and the application will open the excel files, one by one, execute this specific macro, and save it. The parameters for the application will be the directory where the excel files are and the name of the macro. The macro we will do it one time and it will be executes for all files in one directory.
I send you also an aplication that Siralex developed for us. It works ok but just for excel 2007 and it does not respect the graphics position. We need it for excel 2003 also and it should work for a macro that create some graphics and it should respect graphic position in the sheet.