External Data Source Questions
 

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

External Data Source Questions
 

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