Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Loss of focus when recording VB macros

Locked

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?

Topic

Loss of focus when recording VB macros

In reply to Loss of focus when recording VB macros

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

Loss of focus when recording VB macros

In reply to Loss of focus when recording VB macros

Thank you – this has me on my way!

Loss of focus when recording VB macros

In reply to Loss of focus when recording VB macros

This question was closed by the author

[Author]

Replies