Skip to Content
avatar image
Former Member

Refreshing query using macro

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 22 at 05:04 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23 at 10:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06 at 10:52 AM

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

    Add comment
    10|10000 characters needed characters exceeded