>I have an Excel sheet with names and addresses. In Excel the name cell contains a hyperlink to a webpage. I imported the sheet into a vfp table but only get the name not the link. How do I extract the URL portion?

Hi Peter,

Here's one way:

oExcel.ActiveCell.Hyperlinks(1).Name

Let's hear it for Intellisense!