I am running a report in SAP and have a variable for the sls org & DC - download the report and loop to select another sls org repeat until 4 sls orgs have been run and downloaded to excel. Once downloaded - open reports - format and save and email to an outlook user grp depending on the file name(sls org).
So I got the easy part - run report - download - format - email - how do I get it to loop around and select the other 3 sls orgs and repeat. I also have tried two different ways to format the excel report - using hot keys and if statements and also created a macro. Would prefer to use the macro, but I am having issues trying to get the execute macro activity to work as I can not get the excel file to save as an .xlsm.
Any help would be appreciated.