Dear Colleagues,
Our company using SAP Financial Consolidation as an Excel add-in.
We have VBA macro that enables us to update each sheet of Excel file using Application.Run "ImportWorksheet".
Currently we have another complex excel workbook with a lot of sheets and user go thru each sheet, selecting 1 column that corresponds to previous month, then, using add-ins tab in excel Select Financial Consolidation -> Autonomous Mode -> Import -> In Cell Range.
Can you advice VBA Application.Run "XXXXXX" action that can do the same as manual step (Financial Consolidation -> Autonomous Mode -> Import -> In Cell Range)?
Thanks