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

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

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


.