MS Query Button On Spreadsheet?

M

mx-3 for me

Hello All,
Since you were so helpful my first time around on this message board-
thought I would return to ask another question I have.

Is it possible to place the "Refresh Data" button on a spreadshee
while using MS Query? This is so that the user using the spreadshee
wont have to search around for the refresh button and it could be righ
there in front of them.
Thanks in advanced, im sure this is an easy one for you gurus ou
there! :)

Michell
 
F

Frank Kabel

Hi
you may assign the following statement to a button in your sheet:
activeworkbook.refreshall
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queries created by MS Query not in QueryTables collection 1
Missing default cell styles on some large existing spreadsheets 0
Excel 2007 returns data as 2007 table instead of range - how to turn off. 0
Running MS Query on an Excel Spreadsheet 3
changing query source 2
command button to run an Acess query- I know this can be done 2
New twist on a command button for queries- I know this can be done 4
Simple MS Query with Data Parameters Not Auto-refreshing 0

Top