Hi All,

I need to do CTRL A and CTRL C to copy all the data in a webpage.
Can anyone tell me if this syntax is right ?

Application.SendKeys ("^{A}")
Application.SendKeys ("^{C}")

Many Thanks
Ankur

SendKeys should only used as a last resort.

What about a web query instead.
Excel can open html file also if 2002 and up.
+ other options of getting the HTML directly from the server etc.

NickHK

"ankur" wrote in message
oups.com...

Hi All,

I need to do CTRL A and CTRL C to copy all the data in a webpage.
Can anyone tell me if this syntax is right ?

Application.SendKeys ("^{A}")
Application.SendKeys ("^{C}")

Many Thanks
Ankur

Hi Nick,

Thanks a lot for the quick reply.

Yes, I understand that sendkeys have to be used as the last resort.
Still I would like to know can do a Select All and Copy All with send
keys. If yes, then How?

Thanks so much for your help.

Regards
Ankur


On Jan 17, 4:19 pm, "NickHK" wrote:
SendKeys should only used as a last resort.

What about a web query instead.
Excel can open html file also if 2002 and up.
+ other options of getting the HTML directly from the server etc.

NickHK

"ankur" wrote in ooglegroups.com...





Hi All,

I need to do CTRL A and CTRL C to copy all the data in a webpage.
Can anyone tell me if this syntax is right ?

Application.SendKeys ("^{A}")
Application.SendKeys ("^{C}")

Many Thanks
Ankur- Hide quoted text -- Show quoted text -