I have a couple of quick questions.

1) Can I use the xml Document Object in Excel 2000? If So how?

2) Web Query I would like to be able to download the information from my bank statement online but when i go to my bank (www.wamu.com) first i have to click on the personal page then enter in my password and user name. So how can i use a web query to access this table?

3) Is it possible to save data from excel to an external source through code
like if i populate a table with infor from a access database and then i add data to it is it possible to save the changes back to the data source?

4) I Have a cell that i wish to make the sum of all the results of a auto filter filter
so for example if i have a ledger and select the whole ledger and set it to auto filter and the user goes to status and selects open
it will then display all rows that are open i wish the cell tobe the sum of just that and to change with the filter.

Thanks for the help.

WStoreyII

3) There's information here on importing and exporting data:
http://www.erlandsendata.no/english/...php?t=envbadac

4) Use the Subtotal function, and only the visible rows will be
calculated after a filter has been applied. For example:
=SUBTOTAL(9,A2:A500)

WStoreyII wrote:
I have a couple of quick questions.

1) Can I use the xml Document Object in Excel 2000? If So how?

2) Web Query I would like to be able to download the information from my bank statement online but when i go to my bank (www.wamu.com) first i have to click on the personal page then enter in my password and user name. So how can i use a web query to access this table?

3) Is it possible to save data from excel to an external source through code
like if i populate a table with infor from a access database and then i add data to it is it possible to save the changes back to the data source?

4) I Have a cell that i wish to make the sum of all the results of a auto filter filter
so for example if i have a ledger and select the whole ledger and set it to auto filter and the user goes to status and selects open
it will then display all rows that are open i wish the cell tobe the sum of just that and to change with the filter.

Thanks for the help.

WStoreyII


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html