Application.SendKeys not working

[alienscript]

Hi,

In Excel 2003, when I run the following syntax it types out the Vlookup formula in the active cell. Could someone help me why now it doesn't in Excel 2010?

Thanks a bunch!

Application.SendKeys "{F2}=vlookup{(}{,}FALSE{)}{left}{left}{left}{left}{left}{left}{left}", True

[Bob Phillips]

It types it out in my 2010, but it is missing a few values.

[Kenneth Hobs]

If you are running Vista+, you need to turn off Window's UAC for Sendkeys() to work. There are some other methods one can use if you want UAC on.