Skip to Content

refresh a query, by assigning macro to a object


I am trying to use an object on a worksheet to refresh a query on another worksheet. I am not quite sure how we do it.

I looked at the thread, BEx query refresh macro

But, i do not how to use it. please provide suggestions as to how to proceed?



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2007 at 01:58 PM


    Open your workbook, in the bottom pane..right click and go to view code. In that space you have write macro to refresh the other query by using the objects in the query

    There are several threads with codes you can refer

    Assign points if useful


    N Ganesh

    Add a comment
    10|10000 characters needed characters exceeded

    • reposting for suggestions, did not solve my problem yet.

      so far what i know is, i have to assign macro to the object but, do i need record the refresh query or do i need to call the standard funtion,

      "Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

      End Sub"

      But, how do i call or assign this as a macro to the object

      peter knoer, can you provide suggestions?



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.