Key Event within a macro - Space bar

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
 
A

Arvin Meyer [MVP]

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
 
Top