View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Morton David Morton is offline
external usenet poster
 
Posts: 4
Default The dreaded Sendkeys command

Hi,

I have a very repetitive task I have to do sometime next week that
entails entering data into a form created by foxpro. Unfortunately, the
designer of the form did not design the form well, and is no longer with
the company, so the tab-order is incredibly out of whack and doesn't
seem to make any sense. Nevertheless, I am trying to automate the data
entry using Excel, but I have one problem. When I use the following
procedu

Sub CheckIt()
AppActivate ("Microsoft Visual FoxPro")
SendKeys "{TAB}", True
End Sub

everything works great, but when I use the following:

Sub CheckIt()
AppActivate ("Microsoft Visual FoxPro")
SendKeys "+{TAB}", True
End Sub

Absolutely nothing happens. I can't seem to tab backwards, though
tabbing forwards isn't a problem. Any ideas on how to get this to work
better? If I can figure this little thing out, I can save myself a
couple of days of work.

Thanks in advance,

David Morton