Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Copy and Paste from Internet Explorer

4 views
Skip to first unread message

k3h...@gmail.com

unread,
May 27, 2008, 8:58:25 PM5/27/08
to
I want to copy some text from IE and paste it into a worksheet, when I
use the macro recorder it doesn't give me the proper code. If anyone
can get me pointed in the right direction I would greatly appreciate
it. Thanks

Shasur

unread,
May 28, 2008, 2:00:00 AM5/28/08
to
Hi

The best option would to use Internet Explorer Object and get the text using
InnerText or InnerHTML property

The following links can give you some info

http://msdn.microsoft.com/en-us/library/aa752084(VS.85).aspx
http://vbadud.blogspot.com/2008/05/google-search-using-vba.html

Cheers


http://vbadud.blogspot.com

k3h...@gmail.com

unread,
May 28, 2008, 3:16:57 AM5/28/08
to
Thanks for the input. I will give it a look and see if I can get
anywhere from it.
0 new messages