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. Is it posible ? The macro we will do it one time and it will be executes for all files in one directory.