View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default 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