Refreshing query using macro

[Former Member]

Dear all,

I would like to use a macro to refresh my queries on AFO.

Every day I have to update multiple queries (different sheets, same workbook) with date of day before. I would like to know if there exists a macro who can do this job for me.

Thank you in advance

[Former Member]

Hello All,

thank you so much for your quick answer.

It seems like a little bit too difficult for me, because I can use it.

Thank you for your help anyway 😉

[reganmacdonald]

Hi Simon,

I've done a few blog posts that cover this sort of thing, including using dynamic dates to do your updates.

It gives a bit more guidance on top of that Wiki and a bit more functionality.

• Part 1 : https://blogs.sap.com/2016/12/18/automated-updating-of-data-in-excel-files-bex-ao-via-vbavbscript/
• Part 2 : https://blogs.sap.com/2017/01/15/automated-updating-of-bw-data-in-excel-files-bex-ao-via-vbavbscript...
• Part 3 : https://blogs.sap.com/2017/02/03/analysis-for-office-variables-and-filters-via-vba/
• Part 4 : https://blogs.sap.com/2017/02/20/analysis-for-office-and-excel-vba-lessons-learnt/

Part 3 might be of particular use for you in this situation.

Cheers,

Regan

[former_member760987]

Hello,

I created a macro to refresh a BW query after enter the variables in the parameter area. Is not working only for the CC-Hierarchy top node. For individualy cost center is working fine.

my code is

Do you know how I can solve it?

Thank you in advance

[TammyPowlas]

Hello Simon - please see the steps in this wiki: https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=261522552