Ron,

Thank you for your quick response. The code you provided is what I needed.
The reason for the command button is primarily for the end user that does
even know what their ribbon tools are for. Check click a button right in
front of the face.

Also, is it possible to create a form that pops up saying "Please wait while
report queries are running". Then go away when their finished?
--
Thanks, Kevin


"Ron de Bruin" wrote:

You can try this

Application.CommandBars.ExecuteMso ("RefreshAll")

But why not add this button that is in the Data tab on the QAT

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"AFSSkier" wrote in message ...
I have Excel 2007 & want to create a command button to "Refresh All" reports
in a workbook. Which command button would be best & can someone help me with
the code?
--
Thanks, Kevin


"keepITcool" wrote:


Via Data/Import external data
you create a QueryTable.

that querytable can be refreshed when you rightclick it
and choose refresh from the popup.

(alternatively you can put a button next to it to call the refresh
method of the QueryTable object)



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


simsjr wrote :

Hi Folks,

I'm trying to figure out the easiest way to create a spreadsheet
template with an "update" button on it. When clicked, this button
should tell Excel to grab data from an external database and place it
in specified columns. Furthermore, this Excel template should be able
to apply conditional formatting to the new data if it meets certain
criteria.

Do I need to know VB for this, or can a macro do this work for me?



__________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 3946 (20090318) __________

The message was checked by ESET Smart Security.

http://www.eset.com