The hyperlinks are all in a specific column. The links are all to jpg pictures that are all contained in the same folder and location. (some cells have a link , and some do not.)
The links all look like this, with only the file name, "22-1187" in this case, being changed inside each cell that contains a hyperlink.
The links are accessed whenever the user opens a userform to view a specific record. If a picture is available for that record (if there is a hyperlink address available in the cell shown in the previous picture) then it loads the picture into the userform as so: (and if no address is in the specific cell, then it simply ignores the command to populate the frame with a picture)
But here is my big problem....
This only works for me on my work station and computer(!)
The reason for this is that the actual address for the link's location doesnt look like it does in the first picture... No, instead it actually looks like this: (this is what it shows whenever you hover over the cell containing the hyperlink)
As you can see, it no longer directs to "J:\QMS_General Facility\INCIDENT LOGS\....." but instead it has replaced the "J:\" with the prefix: "file:///\\seaserver\mydocs". Well this means that no one else can open up the workbook from their workstation and have the pic feature work for them. boo to that I say. What gives? Is there a way I can force excel to stop from automatically replacing the "J:\" with that "ile:///\\seaserver" nonsense?
I already have the command:
under a workbook open event, but it just ignores that alltogether and changes the links each and every time.
The links all look like this, with only the file name, "22-1187" in this case, being changed inside each cell that contains a hyperlink.
The links are accessed whenever the user opens a userform to view a specific record. If a picture is available for that record (if there is a hyperlink address available in the cell shown in the previous picture) then it loads the picture into the userform as so: (and if no address is in the specific cell, then it simply ignores the command to populate the frame with a picture)
But here is my big problem....
This only works for me on my work station and computer(!)
The reason for this is that the actual address for the link's location doesnt look like it does in the first picture... No, instead it actually looks like this: (this is what it shows whenever you hover over the cell containing the hyperlink)
As you can see, it no longer directs to "J:\QMS_General Facility\INCIDENT LOGS\....." but instead it has replaced the "J:\" with the prefix: "file:///\\seaserver\mydocs". Well this means that no one else can open up the workbook from their workstation and have the pic feature work for them. boo to that I say. What gives? Is there a way I can force excel to stop from automatically replacing the "J:\" with that "ile:///\\seaserver" nonsense?
I already have the command:
VBA Code:
ThisWorkbook.UpdateLinks = xlUpdateLinksNeverunder a workbook open event, but it just ignores that alltogether and changes the links each and every time.
