Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform and Macro code
I have the following code to switch to an open application (ACT! database)
and send the following keys. This works fine as a stand alone macro however, when i add the same code to a button in a User Form, it doesnt work. Can someone help? Sub Export() 'Does an export of the ACT database AppActivate ("ACT!"), True Application.SendKeys ("%f"), True Application.SendKeys ("d"), True Application.SendKeys ("e"), True Application.SendKeys ("{TAB}"), True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEED A MACRO CODE TO USE IN A USERFORM | Excel Discussion (Misc queries) | |||
How to get variables from worksheet code to userform code | Excel Programming | |||
VBA code sort problems - recorded macro does not work with userform | Excel Programming | |||
userform and VBA code | Excel Programming | |||
Help with UserForm Code | Excel Programming |