Download data to Excel

[Sanjay Singh]

I am building a reporting solution with Excel 2000. I would like the
spreadsheet to be able to download data from SQL Server on our website.

The data will go into a specific range on my spreadsheet on which further
calculations can then take place.

If possible I want this to be controlled from Excel i.e. User will press a
button on a customized Excel toolbar which will then run some code to carry
out the above.

Can this be done.

Thanks in advance
Sanjay

 

[Michel Thiffault]

http://www.bcentral.co.uk/technology/office/tips/excel/WebQueries.asp

 

[Sanjay Singh]

I am hoping for a solution that almost acts like a service i.e. the Excel
spreadsheet calls an ASP page that will pass the data invisibly to Excel.
There will be some username and password information as well that the user
will need to pass to the page to ensure that they have access to the
information.

Is there a way using VBA where Excel can request the formation then read
the response from the page.

Regards
Sanjay