Automating a process that uses an add-in
 

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

"Leo Demarce" wrote:

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

"Jim Cone" wrote:

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



"Leo Demarce"

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" wrote:

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

Automating a process that uses an add-in
 

did you try SENDKEYS ?

"Another Jim" <Another wrote in message
...
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

"Leo Demarce" wrote:

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

"Jim Cone" wrote:

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



"Leo Demarce"

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" wrote:

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