Hi Guy,

A good way to do this quickly would be to use a QueryTable (Data | Import
External Data -- New Database Query). You could very easily drop a
CommandButton on the worksheet, set its caption to "Refresh", and set the
code behind it to something like this:

Worksheets("Report").QueryTables(1).Refresh

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Guy wrote:
Hi all,

I need to develop a solution for Excel that will generate reports
from some back-end systems. The user should be able to get updated
data whenever he clicks on a button ...

What is the best way to implement this functionality? Web services
with XML maps, data source queries or something else?

Thanks.