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

[former_member1209881]

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

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

[former_member1204554]

Sorry would you mind sharing your VBA code for "Application.Run "ImportWorksheet""?

Thanks,