473,575 Members | 3,439 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

controlling another application via VBA or javascript code in Excell & sending keystrokes & mouse clicks

I am running Excel2000 under WIN98 2nd edition, and I am writing a VBA
code (I will consider using javascript if I have to) that does the
following, at the user command:
1- Start MS Explorer and go to my website. Login (enter ID and
Password)
2- It will go and update some prices of some products that I sell
3- It will add new products or cancel some product

I already have someone who wrote me in JavaScript a web form (no
documentation what so ever) residing at my wensite, that I enter the
product ID then I press the enter key. Then it will take me to another
web form with multiple hyperlinks and buttons. Each is for certain
task, so I will click with the mouse (no keyboard shortcut, but focus
can be done with Tab key) on the hyperlink with price update. So it
takes me to another web form where there is a small box with the
price, so I click at it with the mouse and change the price. Then with
the mouse I click on a button "FINISHED" (there are three buttons,
none of which uses key board). This takes me to another web form where
I can select other tasks, such as change product limited time
discount, or some description etc. At the bottom of this form there
are two buttons "Cancel" "Update" so I click on "Update". All this is
to change one thing, I have to do this about 40 times a day since I
have added more products and I keep changing the prices or change time
driven special discounts, and others as needed.
I have read under DDE how to pass KEYSTROKES, which seems to be a
crude way, but might be ok. I know that if I pass the TAB key until
the button is highlighted, then send the "enter" keystroke, will work.
But this will not work with clicking on a hyperlink. I also, checked
sending mouse click with (x, y) coordinates, but I think it is not
reliable. There is also the timing issue whether the web form is
completely loaded or not, whether I send the keystrokes too fast. Or
even the wed form is taking too much time to load, where it is best to
terminate it and start another one.

So my question is, is there a way that I can reliably and effectively
get my task done. I read about OLE & ActiveX, and all they explain
about how to control my MS explorer, which is really not what I want.
I want to control the form (the code inside the web page), to make it
think I have clicked on this button or that hyperlink, or entered data
in a text box.

Sorry for the lengthy details.
Jul 23 '05 #1
1 3782
There is no real good way of doing this in JavaScript. Maybe through
the MS scripting host, but I'm not sure.

However if you have access to that webserver, it is not at all
weird to make a webpage that inserts the codes you want.

1. From Excel start IE and direct it to a webpage with the parameters
to insert. for example:

explore.exe http://www.mysite.com/enter.html?productId=xyz&price=1

2. Now enter.html will read those parameters and put them in a hidden
form. The form complies to the normal form you would use to enter
the values, except that this form would read the values that come
with the query (productId=xyz& price=1) and put them in the right fields.

This could easly be done with ASP, JSP, PHP and could even be done in
JavaScript.

3. After the page is complete you submit it to the page that would
normally store the input on the site after the submit.

Though ofcourse, there must be easier ways of doing this.

Good luck,
Vincent
Zaidan wrote:
I am running Excel2000 under WIN98 2nd edition, and I am writing a VBA
code (I will consider using javascript if I have to) that does the
following, at the user command:
1- Start MS Explorer and go to my website. Login (enter ID and
Password)
2- It will go and update some prices of some products that I sell
3- It will add new products or cancel some product

I already have someone who wrote me in JavaScript a web form (no
documentation what so ever) residing at my wensite, that I enter the
product ID then I press the enter key. Then it will take me to another
web form with multiple hyperlinks and buttons. Each is for certain
task, so I will click with the mouse (no keyboard shortcut, but focus
can be done with Tab key) on the hyperlink with price update. So it
takes me to another web form where there is a small box with the
price, so I click at it with the mouse and change the price. Then with
the mouse I click on a button "FINISHED" (there are three buttons,
none of which uses key board). This takes me to another web form where
I can select other tasks, such as change product limited time
discount, or some description etc. At the bottom of this form there
are two buttons "Cancel" "Update" so I click on "Update". All this is
to change one thing, I have to do this about 40 times a day since I
have added more products and I keep changing the prices or change time
driven special discounts, and others as needed.
I have read under DDE how to pass KEYSTROKES, which seems to be a
crude way, but might be ok. I know that if I pass the TAB key until
the button is highlighted, then send the "enter" keystroke, will work.
But this will not work with clicking on a hyperlink. I also, checked
sending mouse click with (x, y) coordinates, but I think it is not
reliable. There is also the timing issue whether the web form is
completely loaded or not, whether I send the keystrokes too fast. Or
even the wed form is taking too much time to load, where it is best to
terminate it and start another one.

So my question is, is there a way that I can reliably and effectively
get my task done. I read about OLE & ActiveX, and all they explain
about how to control my MS explorer, which is really not what I want.
I want to control the form (the code inside the web page), to make it
think I have clicked on this button or that hyperlink, or entered data
in a text box.

Sorry for the lengthy details.


Jul 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
9153
by: Kevin Lyons | last post by:
Hello, Can anyone assist me with what I am trying to do with the following code (six different scenarios to try to make the functionality work correctly)? I want to always (and ONLY) display in the status bar 'Symantec Corporation' whenever anyone mouses over (onMouseOver) my image or link OR when one clicks while holding the left mouse...
3
8974
by: Wayne | last post by:
I have a console application (ssh2.exe) that requires keystrokes to be sent to it after activating. I have worked that it needs to be started in it own thread, but capturing the process and sending the keystrokes escapes me at the moment. Is there any material online that describes the process of sending keystrokes to a console app?
4
10671
by: Steven | last post by:
Hello, I have 3 files -- 1. mainform.aspx 2. mainform.aspx.cs 3. mouse.js mainform.aspx contains a image button ("zoominimgbut") which will exceute C# code, whenever the user clicks on it. mainform.aspx.cs is the code behind for mainform.aspx. Mouse.js contains javascript code which needs to executed
1
1292
by: ljh | last post by:
I want to develop an application that can watch for and monitor any instance of Word 2000/2003. I need to be able to write an add-in menu for Word 2000/2003 and capture all keystrokes and mouse events done in Word also, for a training application. I am searching for all of the code that I can get my grubby little hands on that shows key...
3
5035
by: Gunnar Syren | last post by:
I'm trying to implement a macro feature in my application by recording and playing back keystrokes. At first I thought it would be enough to catch KeyDown in my main form, but I soon realized that I needed to catch keystrokes in menues and other forms in my app as well. I realize I can implement a keyboard hook that catches keystrokes...
2
1482
by: ApexData | last post by:
Hello In order to control keyboard keystrokes in my application, I use the KeyPreview=Yes, OnKeyDown Events of every Form with great success. HOWEVER, these events are not available in REPORTS, opening up my application to ALL Function/Ctrl/Alt keystrokes that a user can fire and cause problems. In STARTUP I have Use Access Special Keys...
12
1832
by: Seth Bourne | last post by:
It is really painfull when migrating from Windows Application to Web Application. it's because web application has so many weakness which have the user to use 'more mouse' than 'keyboard' it self. it's really dont fit for Point of Sale System which is need faster data entry. is it anyway we can handle this ?? Thanks Seth
0
2741
by: neonspark | last post by:
I'm buidling some simple macro functionality for my app so the users can record a sequence of keyboard inputs and replay them reliably via some menu. Originally, I used: protected override bool ProcessCmdKey(ref Message msg, Keys keyData) To map "Keys" objects to their string constant, and stored them on a string Queue as they were...
3
10580
by: Kbalz | last post by:
Hello - I've tried to search this, but the word Focus in searching always returns lots of control focusing. I would like my C# Win App to minimize, and focus a program that is already running, then send mouse clicks / keyboard interaction.. and when complete, restore my app, and focus it of course. My troubles are finding how to focus the...
0
7845
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7775
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8120
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8281
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7868
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6515
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5664
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
1
2286
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1382
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.