Sergey beat you by seconds...

Thanks



>To get intellisense for an object that occurs pretty far down the hiarchy, use a more local reference:
>

oHL = oExcel.ActiveSheet.Range("O141").Hyperlinks
>oHL.

should now show the properties.
>
>
>>hyperlinks is an object but has no intellisens:
>>

>>CLEAR
>>LOCAL oExcel as Excel.Application && to make intellisense happy
>>
>>oExcel=CREATEOBJECT("Excel.Application")
>>oExcel.visible= .F.
>>oExcel.DisplayAlerts = .F.
>>lcFileName=[c:\vApps\vCMC\Imports\MasterList.xls]
>>oW=oExcel.Workbooks.Open(lcFileName)
>>
>>?oExcel.ActiveSheet.Range("O141").Hyperlinks   <<<---- returns an object but adding a dot shows no Intellisense
>>
>>?oExcel.ActiveSheet.Range("O141").Hyperlinks.Item(1) <<< --- ole eror code 0x8002000b invalid index
>>
>>
>>

>>
>>
>>>>I get this error:
>>>>
>>>>member ITEM does not evaluate to an object
>>>
>>>It works fine for me in Excel 2007. Anyway try
>>>

>>>? oSheet.Range("O141").Hyperlinks.Item(1).Address
>>>

If it doesn't work, use Intellisense to pinpointe where it brakes.