Skip to Content
0
Former Member
May 12, 2008 at 05:28 PM

Workbook jump and refresh (URGENT)

16 Views

Dear all

I have a button in my workbook and I have 3 queries in it, when i hit the button which i have created, i need all the queries in workbook to be refreshed one by one, I am not familiar with VB. Could you please assist me with the code for a macro.

I also need to jump to a different workbook (Query) by right click on a cell and the value of that cell is a input variable to the target query. I am sure i can use RRI if its from query to query. but i need VB code which picks the value from the cell and sends it to target query which is also in a workbook.

Thank you very much.

Vardhan