ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Simulate left click... (https://www.excelbanter.com/excel-programming/393158-simulate-left-click.html)

Udd.

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...

Tim

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...




Tim Williams

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...







All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com