W
WStoreyII
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
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