Key Event within a macro - Space bar

  • Thread starter Thread starter Neal C
  • Start date Start date
N

Neal C

Hi All
I am trying to create a macro that opens an external application from my
database. I can get the application open but now I need the macro to make
some key strokes. The first one is the 'space bar'. Can anyone suggestion the
best options and an example?
Thanks
 
Can't do much with a macro but in VBA code, it would be an empty string:


Function ExcelSpace()
Dim x
x = Shell("Excel.exe", 1)
AppActivate x ' Activate Excel
SendKeys " " & "Arvin" & " ", True
End Function
 
You must log in or register to reply here.

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

Need help on VBA excel macro and API to close an external application 0
Application Follow Hyperlink and MS Word Macro 1
Scroll bar space 1
Macro for data and time 2
deleted a custom menu bar, now getting macro error 3
VBA: calling sdk function sendmessage from access fails for keyup, keydown, WM_SETTEXT 0
Search access Macros, Forms and VBA code for a specific table references 2
Insufficient disk space to fix volume bitmap. chkdsk aborted 4

Back
Top