| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reading password-protected, open webpage
I monitor the performance of my 401(k) by downloading prices from yahoo.com, using VBA of course. This has become a daily routine. With fund prices and number of shares per fund I can determine the dollar value of each fund (i.e., current balance). Problem is, the number of shares per fund is not something I can download using VBA. This is because the fund manager's website is password-protected
Is it possible to read from an open webpage? If I were to establish the target html in a separate IE window, can I use VBA code to read from it? That is, rather than navigating to the URL and usin CreateObject("InternetExplorer.Application").Docum ent.Body.innerTex Thanks Kevin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PAssword protected file will not open | Excel Discussion (Misc queries) | |||
| Make Workbook Password protected tp open | Excel Discussion (Misc queries) | |||
| How to delete a password in a protected file that you can't open? | Excel Discussion (Misc queries) | |||
| Cannot open password-protected Excel File | Excel Discussion (Misc queries) | |||
| open Access DB that is password protected | Excel Programming | |||
Threaded Mode
