refresh a query, by assigning macro to a object

[former_member199573]

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,

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

Thanks,

raj

[Former Member · Accepted solution]

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

[former_member199573 · Accepted solution]

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.