Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Simulate left click...

I've generate an excel report which is sent via text over the internet 3
times a day(Through Esendex). At the moment it is automatied by using
sendkeys, messy but works... I've written the code to move the mouse to
certain areas of the web form that need filling out depending on the screen
resolution planning to get rid of majority of the send keys option. However -
i can not for the life of me figure out how to simulate a left click to make
parts of the form active. I've tried vbkeyslbutton and such like but this
generates a '1' rather than a left click.

Can anyone help at all please...please...
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 145
Default Simulate left click...

In most cases when automating a web interface it's better to ditch the
sendkeys and instead directly automate the browser.

Assumptions:
1. You're using a browser (such as IE) which exposes a COM automation
interface
2. The web UI is HTML-coded, not (Eg.) Flash or a Java applet

Search this newsgroup in Google groups for "automate IE"

Tim


"Udd." wrote in message
...
I've generate an excel report which is sent via text over the internet 3
times a day(Through Esendex). At the moment it is automatied by using
sendkeys, messy but works... I've written the code to move the mouse to
certain areas of the web form that need filling out depending on the
screen
resolution planning to get rid of majority of the send keys option.
However -
i can not for the life of me figure out how to simulate a left click to
make
parts of the form active. I've tried vbkeyslbutton and such like but this
generates a '1' rather than a left click.

Can anyone help at all please...please...



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default Simulate left click...

Better - the Esendex web site has information on various SDK's (including
one for VB) which can be used to send messages directly, without needing to
use their web pages.

Tim


"Tim" <tim j williams at gmail dot com wrote in message
...
In most cases when automating a web interface it's better to ditch the
sendkeys and instead directly automate the browser.

Assumptions:
1. You're using a browser (such as IE) which exposes a COM automation
interface
2. The web UI is HTML-coded, not (Eg.) Flash or a Java applet

Search this newsgroup in Google groups for "automate IE"

Tim


"Udd." wrote in message
...
I've generate an excel report which is sent via text over the internet 3
times a day(Through Esendex). At the moment it is automatied by using
sendkeys, messy but works... I've written the code to move the mouse to
certain areas of the web form that need filling out depending on the
screen
resolution planning to get rid of majority of the send keys option.
However -
i can not for the life of me figure out how to simulate a left click to
make
parts of the form active. I've tried vbkeyslbutton and such like but this
generates a '1' rather than a left click.

Can anyone help at all please...please...





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
No left click NasaDBGuy Excel Discussion (Misc queries) 0 April 13th 10 07:49 PM
More than one cell is selected when I left click. Why? womusic New Users to Excel 6 May 12th 09 03:55 PM
ALT & left click sby Excel Discussion (Misc queries) 0 May 29th 07 11:17 AM
Simulate Click Event ben Excel Programming 5 June 9th 05 09:45 PM
Run some code on a left click cdb Excel Programming 5 June 4th 05 01:21 PM


All times are GMT +1. The time now is 06:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"