Discussion Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I wish to record a macro in Microsoft Project 2000 that starts a companion product's macro (ProChain Solutions) and marks a checkbox in ProChain's form. Unfortunately, Project's macro recorder gives up the focus when ProChain's form is opened. Is there a trick to keeping the macro recorder recording in such a situation?
3 replies
by dklippert
You could use SendKeys.
Here?s a sample from the VB Help file:
Dim ReturnValue, I
' Run Calculator.
ReturnValue = Shell("CALC.EXE", 1)
' Activate the Calculator.
AppActivate ReturnValue
' Set up counting loop.
For I = 1 To 100
' Send keystrokes to Calculator
' to add each value of I.
SendKeys I & "{+}", True
Next I
' Get grand total.
SendKeys "=", True
' Send ALT+F4 to close Calculator.
SendKeys "%{F4}", True
Thank you - this has me on my way!
This question was closed by the author
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
0 helpful
1 reply
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
Question Unanswered
How can developers improve performance on content-heavy websites?
0 helpful
0 replies
Question Unanswered
How do you protect downloadable files on a WordPress store?
0 helpful
0 replies