PDA

View Full Version : Application.SendKeys not working



alienscript
11-16-2010, 11:38 PM
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
11-17-2010, 01:15 AM
It types it out in my 2010, but it is missing a few values.

Kenneth Hobs
11-17-2010, 05:12 AM
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.