VBA VLookup from excel to Project 2007 - Urgent help needed

[tmdrake]

I am trying to import data from excel to Project 2007 using vba vlookup: this
is what I am using:

TempPercent = xlApp.ActiveWorkbook.Application.WorksheetFunction.VLookup _
(TaskName, Range("A46"), 2, False) * 100


However, I keep geting an error message: Runtime error 1004, unable to get
the vlookup property of the worksheet function class:

Any help on this would be greatly appreciated.


Thanks