Skip to Content
author's profile photo raja s
0
raja s

refresh a query, by assigning macro to a object

Posted on Jan 06, 2007 at 01:07 AM 14 Views

Hi,

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?

Thanks,

raj

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

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

    Hi

    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

    Thanks

    N Ganesh

    Add a comment
    10|10000 characters needed characters exceeded

    • raja s
      Jan 08, 2007 at 07:07 AM

      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?

      Thanks,

      raja.

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.