Access Automation outside of Microsoft

[FpwL1399]

Well I've gotten Access to open another program ouside of the microsoft
domain, but I would like it to preform some commands in that program.
Is there a way to make Access preform keystrokes or mouse strokes? It
would be a very short recording. Four key strokes or 3 mouse clicks.
Any help is welcome.

 

[Douglas J. Steele]

You can use SendKeys to send key strokes, but it's not really recommended.
If the focus should somehow change, the key strokes would be sent to the
wrong application.

There's no way that I'm aware of to send mouse clicks from Access.

 

[FpwL1399]

I found the sendkeys function, but what is the sintax for it? It says
that you have to use VB sintax. I don't know what that is.

 

[Douglas J. Steele]

These should get you going:

http://msdn.microsoft.com/library/en-us/script56/html/4b032417-ebda-4d30-88a4-2b56c24affdd.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vastmsendkeys.asp

(Just a repetition that this is not a good idea!)

 

[FpwL1399]

Is there a better way to get this done?

These should get you going:

http://msdn.microsoft.com/library/en-us/script56/html/4b032417-ebda-4d30-88a4-2b56c24affdd.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vastmsendkeys.asp

(Just a repetition that this is not a good idea!)

 

[Douglas J. Steele]

If the application in question doesn't support automation, there probably is
no reliable approach.

What's the application?

 

[FpwL1399]

The application is Northwest Analytical, Quality Analyst. There's a
way to write macros in it, but it is in a completely different
language.

 

[FpwL1399]

Actually, never mind. The NWA program has a automated macro creator in
it. So I believe that I have solved all of my problems. thanks for
all your help.