>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!