Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating a process that uses an add-in
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating a computation process | Excel Worksheet Functions | |||
Automating online report creating process | Excel Programming | |||
automating a process in pivot tables | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming |