Add a *working* hyperlink into existing hyperlink field using vba

**Zandia** · 06-10-2016, 07:16 PM

I have a hyperlink field named [Doc Folder] which I want automatically populated. I've already have the string the hyperlink that I want to assign to [Doc Folder]. However, when I assign it to the field, it only shows as text and is not follow-able. How do I fix this so that the text becomes a real link?

Please Login or Register  to view this content.

**ranman256** · 06-13-2016, 04:03 PM

Paste this code into a module, and it will open ANY file in its native application.

usage:
OpenNativeApp "c:\folder\file.pdf",will open it in acrobat
OpenNativeApp "c:\folder\file.doc", will open the doc in Word.
OpenNativeApp "c:\folder\", will open the browser, (web sites too)

Please Login or Register  to view this content.

**Zandia** · 06-13-2016, 05:49 PM

I wasn't trying to *open* the link, I was trying to *store* the string as a link. In any case, I've solved my own problem but thanks for the response. Although my code could possibly be cleaned up a bit, it seems to do exactly what I want it to do:

Please Login or Register  to view this content.

Add a working hyperlink into existing hyperlink field using vba

LinkBack

Thread Tools

Rate This Thread

Display