A
Albert
I need to import a list of hyperlinks from an excel worksheet into an access
database. However I firstly need to format the hyperlink address before I
can import it. I have been given the following suggestion
"I don't know a simple way of doing this and have never had to do it in
real life. It should be possible along these lines, though with luck
someone else will have a much more elegant suggestion:
1) put the custom worksheet functions below into a module. They extract
the hyperlink information from the Excel cells.
2) add a column to a copy of your worksheet, and use a formula like
this:
=GetHyperlinkText(B2)&"#"&GetHyperLinkURL(B2)&"#"&GetHyperlinkSubAddress(B2)
to assemble the bits of hyperlink information into a string in the
format used in Access hyperlink fields.
3) delete the hyperlink column. Select the entire worksheet and do
Edit|Copy, then Edit|Paste Special|Values to replace the formulas with
the actual values. "
I am not sure if this works and how to implement the solution.
All help is greatly appreciated.
database. However I firstly need to format the hyperlink address before I
can import it. I have been given the following suggestion
"I don't know a simple way of doing this and have never had to do it in
real life. It should be possible along these lines, though with luck
someone else will have a much more elegant suggestion:
1) put the custom worksheet functions below into a module. They extract
the hyperlink information from the Excel cells.
2) add a column to a copy of your worksheet, and use a formula like
this:
=GetHyperlinkText(B2)&"#"&GetHyperLinkURL(B2)&"#"&GetHyperlinkSubAddress(B2)
to assemble the bits of hyperlink information into a string in the
format used in Access hyperlink fields.
3) delete the hyperlink column. Select the entire worksheet and do
Edit|Copy, then Edit|Paste Special|Values to replace the formulas with
the actual values. "
I am not sure if this works and how to implement the solution.
All help is greatly appreciated.