B
Bettergains
Hello: need someones expertise:
Objective: put the Excel hyperlink path and formula in an access query /
table field so that I can paste / pull it into Excel into an Excel hyperlink
field. OR, need to pull in / paste working hyperlinks into Excel from
Access.
What I have now: a text field in Access with "=hyperlink(path)"
What is missing: hyperlink path name per Excel: above & "link"
Stumbling over nested " " in the text line that would include the hyperlink
name as in Excel it is required to be enclosed in " ".
In the name, I'm actually referencing another field in my query so it would
be "[number]". Access thinks this is a separate string and I haven't found
how to include the " ". Have tried many combinations of the "" and &
operator.
Very appreciative~
Objective: put the Excel hyperlink path and formula in an access query /
table field so that I can paste / pull it into Excel into an Excel hyperlink
field. OR, need to pull in / paste working hyperlinks into Excel from
Access.
What I have now: a text field in Access with "=hyperlink(path)"
What is missing: hyperlink path name per Excel: above & "link"
Stumbling over nested " " in the text line that would include the hyperlink
name as in Excel it is required to be enclosed in " ".
In the name, I'm actually referencing another field in my query so it would
be "[number]". Access thinks this is a separate string and I haven't found
how to include the " ". Have tried many combinations of the "" and &
operator.
Very appreciative~