How to upload WITH Images (Hyperlinks)

someone · #1 04-01-2014, 12:49 AM

hi
in job we have intranet which is accessable only for employers within company. I got some kind of admin access and would need to upload excel's xlsx file. But the problem is that this file contains images in HYPERLINKS. I know the path on local (internal in pc hardware) hard drive to this images. It is defined in xlsx file. Even if I knew how to change hyperlinks' paths to all of them at the same time (I don't know, if you would tell me I would appreciate) it wouldn't help because I don't know what kind of path would i need to use on intranet. So im asking how could i upload file so hyperlinks/images would be ''integrated'' inside the actual excel file?

Note: i need to remain having hyperlinks. All of them to exact images. Uploading images on intranet server won't help because my purpose it to upload only one file and in this single file images/hyperlinks must remain working.

Note2: i repeat again i have no idea what kind of new path would i need to use so just explaining how to change all paths for all hyperlinks at the same time (to new intranet path) won't help.

someone · #2 04-01-2014, 01:34 AM

noone knows?

macropod · #3 04-01-2014, 06:05 PM

You may be able to achieve what you're after by deleting the Hyperlink Address, retaining just the SubAddress. You can do that with a macro using code like:

Code:

Sub Test()
Dim xlWkSht As Worksheet, HLnk As Hyperlink
For Each xlWkSht In ThisWorkbook.Worksheets
  For Each HLnk In xlWkSht
    With HLnk
      .Address = ""
      .ScreenTip = .SubAddress
    End With
  Next
Next
End Sub

Test on a copy of your workbook before doing it on the one you want to use.

PS: A little patience wouldn't go astray. A follow-up less than an hour after the original post isn't likely to endear you to anyone...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
microsoft office upload center msosync.exe	q_auth6	Office	5	11-26-2013 02:49 PM
Hyperlinks on images in oft template files	ianhornby	Outlook	1	01-10-2012 05:47 PM
MS Word 2007 error when trying to upload .doc or .docx to a webpage	heretical1	Word	0	10-06-2010 12:20 PM
Image Upload template.	vvnaga	Word	0	12-29-2009 02:51 AM
Please help .. cannot upload	davee9th	Misc	0	07-02-2006 05:45 AM