Best Way to Pull in Hyperlinks (from Access to Excel)

B

Bettergains

Hello:
What is your best recommendation for pulling in web hyperlinks from a text
field in Access. They are not being used as hyperlinks in Access, rather I am
storing the Excel hyperlink formula (although struggling w/ the syntax for
nested "" in Access). So I have "=hyperlink(path)". Need to add the
hyperlink name (in Excel syntax) which would be "[name]". Thinking i can
then pull / paste this into Excel and Excel will recognize as a hyperlink,
and show as a link (underlined hyperlink name).

Do you have a better idea? Can you help me solve my problem with using
nested "" in Access so that it will include the "" in the hyperlink formula
text, rather than thinking it is another string? (ie, omits the "" required
by the excel formula in the name part of the hyperlink path).

Very appreciative~
 
Top