Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SENDKEYS COMMAND
Hi,
My name is Frankie. I am trying to create a macro to key in something repeatedly from an Excel spreadsheet into an input in an intranet website. However, the sendkey command like ctrl-F "sendkeys ^F or ^V" which represented "Find" or "Paste" functions did not work in my macro. Is there any ways to get round of it ? Thanks for your advice in advance. Rgds, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SENDKEYS COMMAND
I think the command should be written as
SendKeys "^F" greetz "Frankie" schreef in bericht ... Hi, My name is Frankie. I am trying to create a macro to key in something repeatedly from an Excel spreadsheet into an input in an intranet website. However, the sendkey command like ctrl-F "sendkeys ^F or ^V" which represented "Find" or "Paste" functions did not work in my macro. Is there any ways to get round of it ? Thanks for your advice in advance. Rgds, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SENDKEYS COMMAND
"^F" is correct for sending ctl+f but you have to activate the browser first
and send key strokes to that. Sendkeys are rarely the best way to go, i am attaching the best link i've found for interacting with web pages, read up and download his examples, he shows you how to enter data directly into textboxes etc. be aware that while there might be a VB version in there somewhere, his samples are in .NET, which you should still be able to download for free (express version) or adapt for vb. http://www.vbforums.com/showthread.php?t=416275 -- -John Please rate when your question is answered to help us and others know what is helpful. "Frederik" wrote: I think the command should be written as SendKeys "^F" greetz "Frankie" schreef in bericht ... Hi, My name is Frankie. I am trying to create a macro to key in something repeatedly from an Excel spreadsheet into an input in an intranet website. However, the sendkey command like ctrl-F "sendkeys ^F or ^V" which represented "Find" or "Paste" functions did not work in my macro. Is there any ways to get round of it ? Thanks for your advice in advance. Rgds, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
SENDKEYS COMMAND
Hi John,
I understand that sendkeys is not the best solution. However, I am not an expert to VB programming. Sendkeys become the easiest solution. I have already activated IE by "Appactivate" but the "^F" or "^V" buttons did not activate. Is it a limitation of sendkeys statement in IE programs or there is another way to solve the problem. I have tried to activate menu commands for paste by "%EP" and it works. Nevertheless, some of the intranet environment are restricted and main menus are disabled. Can you figure out a simple solution ? Rgds, Frankie "John Bundy" wrote: "^F" is correct for sending ctl+f but you have to activate the browser first and send key strokes to that. Sendkeys are rarely the best way to go, i am attaching the best link i've found for interacting with web pages, read up and download his examples, he shows you how to enter data directly into textboxes etc. be aware that while there might be a VB version in there somewhere, his samples are in .NET, which you should still be able to download for free (express version) or adapt for vb. http://www.vbforums.com/showthread.php?t=416275 -- -John Please rate when your question is answered to help us and others know what is helpful. "Frederik" wrote: I think the command should be written as SendKeys "^F" greetz "Frankie" schreef in bericht ... Hi, My name is Frankie. I am trying to create a macro to key in something repeatedly from an Excel spreadsheet into an input in an intranet website. However, the sendkey command like ctrl-F "sendkeys ^F or ^V" which represented "Find" or "Paste" functions did not work in my macro. Is there any ways to get round of it ? Thanks for your advice in advance. Rgds, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inconsistent Operation of SendKeys Command | Excel Programming | |||
SendKeys command to select an OptionButton | Excel Programming | |||
The dreaded Sendkeys command | Excel Programming | |||
Sendkeys VBA and command line | Excel Programming | |||
SendKeys command not focusing on the correct open program | Excel Programming |