Skip to Content
0
Feb 09, 2023 at 03:51 PM

SAP Financial Consolidation Excel Link - Import cell range using VBA in excel

349 Views

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