Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ksg
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the format of an Excel output file made by Microsoft Access Amir Excel Discussion (Misc queries) 2 May 1st 05 12:57 AM
Opening an Excel file Sheldon Zaklow Excel Discussion (Misc queries) 0 March 3rd 05 11:29 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . DUFFER8MCD Excel Discussion (Misc queries) 1 December 24th 04 12:32 AM
double click a xls file and start Excel but without the file Danyi, Attila Excel Discussion (Misc queries) 2 December 22nd 04 03:19 PM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"