Skip to Content
0

Refreshing query using macro

Jan 22 at 05:04 PM

58

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tammy Powlas
Jan 22 at 05:04 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Regan MacDonald Jan 23 at 10:24 AM
0

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 3 might be of particular use for you in this situation.

Cheers,

Regan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 06 at 10:52 AM
0

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 ;)

Share
10 |10000 characters needed characters left characters exceeded