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

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")

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

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



"Leo Demarce"
<(E-Mail Removed)>
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

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"
> <(E-Mail Removed)>
> 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
>

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"
> > <(E-Mail Removed)>
> > 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
> >

did you try SENDKEYS ?

"Another Jim" <Another (E-Mail Removed)> wrote in message
news41968FB-58D1-44CD-B357-(E-Mail Removed)...
> 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"
>> > <(E-Mail Removed)>
>> > 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
>> >