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