D
Dkline
We have an Excel file with about a 1000 rows. In each row is a file
hyperlink to one of our servers for a document pertaining to that customer.
Once a month we import this spreadsheet into Access by an Access macro.
When we run the macro to do a TransferSpreadsheet the hyperlinks lose their
link. The text is of the UNC is there but the hyperlink is lost. Basically
the "File///" has been stripped away. The hand indicating a hyperlink still
appears, you can click on the link, and we end up in Windows Explorer as it
can't find the file.
I did a cheap solution of doing a Search and Replace and appended the
"File///" to each record in the hyperlink field. Looks ugly on the screen
but it works.
Any particular reason why the hyperlink was stripped on import? Any way
around it?
We do have the "Hyperlink base" set in both Excel and Access for these files
to the same location: \\Server03\Shared\.
hyperlink to one of our servers for a document pertaining to that customer.
Once a month we import this spreadsheet into Access by an Access macro.
When we run the macro to do a TransferSpreadsheet the hyperlinks lose their
link. The text is of the UNC is there but the hyperlink is lost. Basically
the "File///" has been stripped away. The hand indicating a hyperlink still
appears, you can click on the link, and we end up in Windows Explorer as it
can't find the file.
I did a cheap solution of doing a Search and Replace and appended the
"File///" to each record in the hyperlink field. Looks ugly on the screen
but it works.
Any particular reason why the hyperlink was stripped on import? Any way
around it?
We do have the "Hyperlink base" set in both Excel and Access for these files
to the same location: \\Server03\Shared\.