Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select open webpage, copy information to open worksheet
I've developed (with much help from this forum) a workbook that helps me
monitor my 401(k). It maintains price, share and balance information for 32 funds. Prices are obtained automatically from http://finance.yahoo.com. But obtaining share information requires much manual work. I used to be able to automatically open a secure webpage and copy share balances. But the investment company has made changes that prevent this. I'd like to be able to copy the share balances from an open webpage. That is, I propose to manually open the investment company's secure webpage and then activate a Excel VBA program to copy information from the open webpage to a worksheet. I'll need to screen URLs because I may have several open webpages. Any help will be greatly appreciated. Thanks much. -Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select open webpage, copy information to open worksheet
I'll be more specific. How would I use the GetObject function to copy
information from an open webpage? The GetObject Function Example in Microsoft Visual Basic Help (for Excel) only shows how to us "[...] the GetObject function to get a reference to a specific Microsoft Excel worksheet (MyXL). " Thanks. Kevin -- -Kevin I wrote: I've developed (with much help from this forum) a workbook that helps me monitor my 401(k). It maintains price, share and balance information for 32 funds. Prices are obtained automatically from http://finance.yahoo.com. But obtaining share information requires much manual work. I used to be able to automatically open a secure webpage and copy share balances. But the investment company has made changes that prevent this. I'd like to be able to copy the share balances from an open webpage. That is, I propose to manually open the investment company's secure webpage and then activate a Excel VBA program to copy information from the open webpage to a worksheet. I'll need to screen URLs because I may have several open webpages. Any help will be greatly appreciated. Thanks much. -Kevin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
select open webpage, copy information to open worksheet
Kevin,
One way would be put a webbrowser control on a userform, Navigate2 the required webpage, fill in login etc. Once you are on the correct page, read the HTML/DOM to get the data. This can get you started: http://www.microsoft.com/mind/0898/dom.asp Google for "Automate IE VB -Net" (without the quotes) to get some other leads. NickHK "Kevin" wrote in message ... I'll be more specific. How would I use the GetObject function to copy information from an open webpage? The GetObject Function Example in Microsoft Visual Basic Help (for Excel) only shows how to us "[...] the GetObject function to get a reference to a specific Microsoft Excel worksheet (MyXL). " Thanks. Kevin -- -Kevin I wrote: I've developed (with much help from this forum) a workbook that helps me monitor my 401(k). It maintains price, share and balance information for 32 funds. Prices are obtained automatically from http://finance.yahoo.com. But obtaining share information requires much manual work. I used to be able to automatically open a secure webpage and copy share balances. But the investment company has made changes that prevent this. I'd like to be able to copy the share balances from an open webpage. That is, I propose to manually open the investment company's secure webpage and then activate a Excel VBA program to copy information from the open webpage to a worksheet. I'll need to screen URLs because I may have several open webpages. Any help will be greatly appreciated. Thanks much. -Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel ... Select WorkSheet | Excel Discussion (Misc queries) | |||
Open a webpage using Javascript in Excel | Excel Programming | |||
Open webpage | Excel Programming | |||
Open webpage | Excel Programming | |||
Open Webpage and then Run Code | Excel Programming |