SENDKEYS COMMAND

[Frankie]

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,

 

[Frederik]

I think the command should be written as

SendKeys "^F"

greetz

 

[John Bundy]

"^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

 

[Frankie]

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