VBA query

  Chas49 15:42 09 Apr 2010
Locked

Is it possible to use the Sendkeys instruction in VBA Office 2007 when running Win 7. I have not , so far, been able to do this. Is the instruction still valid?

  VoG II 16:16 09 Apr 2010

Yes it is. With Excel 2007 running under Windows 7


Sub test()
SendKeys "{F1}"
DoEvents
End Sub


launches Help.

  VoG II 16:17 09 Apr 2010

By the way, SendKeys is notoriously flaky.

  Chas49 16:24 09 Apr 2010

As usual VoG™ you've saved the day! I was forgetting the DoEvents instruction! Where would be without the likes of you - up the creek!!

Many thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?