"Chip Pearson" wrote in news:eE1stOGQFHA.1096
@tk2msftngp13.phx.gbl:

Try,

Dim Result
Result = objXL.Run("test")


Hi Chip

Thanks for the reply. Unfortunately this won't work because a parameter must
be passed to this function. After many hours of trial and error, I moved the
function under the 'Sheet1' object and called the function in this manner:

tmp = ObjXL.WorkSheets("Sheet1").getValue("Hello")

It worked. :)

Take care