Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
No left click | Excel Discussion (Misc queries) | |||
More than one cell is selected when I left click. Why? | New Users to Excel | |||
ALT & left click | Excel Discussion (Misc queries) | |||
Simulate Click Event | Excel Programming | |||
Run some code on a left click | Excel Programming |