Copy and Paste from Internet Explorer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

k3homes@gmail.com - 28 May 2008 01:58 GMT

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

Reply to this Message

Shasur - 28 May 2008 07:00 GMT

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

> 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

Reply to this Message

k3homes@gmail.com - 28 May 2008 08:16 GMT

Thanks for the input. I will give it a look and see if I can get
anywhere from it.

Reply to this Message