Userform and Macro code

S

sunspot27

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Excel VBA and Sendkeys Office 2003 under XP vs Office 2007 under V 4
Send unattended email from Outlook using Excel macro 3
XP Problems with SendKeys - dialing a number in an Excel cell 1
Dialer.exe - I am actually trying to get dialer.exe to dial Excel cell phone numbers. I am using Exc 1
Macro to Select text from a point given to a specific word 2
SendKeys to open application 4
How to clear a batch of VBA projects' passwords 0

Top