Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlinks change when Excel file is saved to a different director
I have an Excel Spreadsheet that I insert hyperlinks to .pdf files from Vb.
As long as the sheet with the hyperlinks stays in the original directory everything is fine. The problem occurs when the users saves the sheet in another directory - the save changes the hyperlink directory to the new directory even though the linked file has not moved. Is ther a way for me to write the hyperlink statement to make is a constant? VB Code is as follows: ActiveSheet.Hyperlinks.Add Anchor:=ActiveSheet.Cells(brow, col), Address:=repdir, _ TextToDisplay:=reportname Any help appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
Opening an Excel file | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . | Excel Discussion (Misc queries) | |||
double click a xls file and start Excel but without the file | Excel Discussion (Misc queries) |