SendKeys Help
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 Help
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 |
SendKeys Help
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 - |
All times are GMT +1. The time now is 04:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com