VBA query

  Chas49 15:42 09 Apr 2010

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}"
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

Huawei MateBook X Pro review

8 digital brands that designed custom typefaces to save millions

How to speed up a slow Mac

Comment résoudre des problèmes d’impressions ?