Automating a process that uses an add-in

[Leo Demarce]

I have a process that I do repeatedly that I would like to create a macro for
but can't figure out how. There is an add-in command that can be called by
using the keyboard shortcut of CTRL+SHIFT+V. This command bring up a dialog
box that all I want to do is select the OK button which can be called by
using the keyboard shortcut of ALT+O.

In other words, the manual process is
CTRL+SHIFT+V
ALT+O

Thanks in advance for any input.
Cheers
Leo

 

[jasontferrell]

Sub test()
SendKeys "^+v", True
SendKeys "%o", True
End Sub

You might also need to add a pause in the middle, something like:
Application.Wait Now() + TimeValue("0:00:01")

 

[Leo Demarce]

Perhaps I can add more info here. The first part of the macro was to record
CTRL+SHIFT+V which created the code below. Now that the dialog box is up how
do I send the command ALT+O (the ok button on the form).

Cheers

Application.Run "xFRView"

 

[Jim Cone]

Is it a dialog box or a userform?
In any case, have you tried the enter key?
--
Jim Cone
Portland, Oregon USA



"Leo Demarce"
<[email protected]>
wrote in message
Perhaps I can add more info here. The first part of the macro was to record
CTRL+SHIFT+V which created the code below. Now that the dialog box is up how
do I send the command ALT+O (the ok button on the form).

Cheers

Application.Run "xFRView"

 

[Leo Demarce]

Thanks Jim,

I think it would be a userform
I did try the enter key, but it doesn't do it, only the ALT+O
Cheers

 

[Another Jim]

Did anyone ever figure this out? I'm a novice with VB and I have an Add-in
to Excel that I need to activate using a macro. To activate it, I need to
use ALT+A, but I can't figure out how to send this command.
thanks much,
Another Jim

 

[Patrick Molloy]

did you try SENDKEYS ?

Did anyone ever figure this out? I'm a novice with VB and I have an
Add-in
to Excel that I need to activate using a macro. To activate it, I need to
use ALT+A, but I can't figure out how to send this command.
thanks much,
Another Jim