Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

extract URL from column

Status
Not open for further replies.
Sep 25, 2002
159
US
Hi everyone,

I have an imported table that contains a column that is a hyperlink. For example, one entry is 'PDP Dashboard', if you click on it, it will take you to a webpage. How do I extract the URL's from these entries? I can't just extract the value of the column since it would give me 'PDP Dashboard'.

Thank you,

SR
 
Hello:

I do not know of any other way except to copy the URL from your browser when the page opens.

Regards
Mark
 
Have a look at the HyperlinkPart method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Thanks PHV, this is exactly what I was looking for.

HyperLinkPart(myField, acAddress)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top