| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing query data via vba button
I have a wookbook which has 5 worksheets that contains sql query's that are
bulling data from an access 2003 db, instead of me right clicking on each worksheet to refresh the data, is there any vba code that i can import that will enable the user to refresh the worksheet via a single button, been racking my brain, could someone help me please.............!!!!!!!!!!!!!!!!! -- RzaXL |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refreshing query data via vba button
ThisWorkbook.RefreshAll
MIke F "rzaxl" wrote in message ... I have a wookbook which has 5 worksheets that contains sql query's that are bulling data from an access 2003 db, instead of me right clicking on each worksheet to refresh the data, is there any vba code that i can import that will enable the user to refresh the worksheet via a single button, been racking my brain, could someone help me please.............!!!!!!!!!!!!!!!!! -- RzaXL |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refreshing query data via vba button
thanks
-- RzaXL "Mike Fogleman" wrote: ThisWorkbook.RefreshAll MIke F "rzaxl" wrote in message ... I have a wookbook which has 5 worksheets that contains sql query's that are bulling data from an access 2003 db, instead of me right clicking on each worksheet to refresh the data, is there any vba code that i can import that will enable the user to refresh the worksheet via a single button, been racking my brain, could someone help me please.............!!!!!!!!!!!!!!!!! -- RzaXL . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop automatic data reformat when refreshing a query | Excel Discussion (Misc queries) | |||
| Refreshing Data from a web query | Excel Discussion (Misc queries) | |||
| Simple MS Query with Data Parameters Not Auto-refreshing | Excel Discussion (Misc queries) | |||
| problem refreshing data query on yahoos | Excel Discussion (Misc queries) | |||
| Query to external data not refreshing | Excel Discussion (Misc queries) | |||
Linear Mode
