Bookmark in Hyperlink Question

M

Maperalia

I have an excel file located in the "O" drive that has a hyperlink pointed
with specific bookmarks (O:\Book1.xls-Sheet2!A1)

However, when I save as this excel file into the “C†drive the new file
keeps the hyperlink and bookmarks from the “Oâ€.

If there is many way to save as the excel file from the “O†drive into the
“C†and the hyperlink with its respectively bookmark into the “C†drive
(C:\Book1.xls-sheet2!A1).

Thanks in advance.
Maperalia
 
×

מיכ×ל (מיקי) ×בידן

I didn't check this but it seems to be OK.
Run the following macro before saving the WB in Drive C
------------------------------------------
Sub Change_HL_Drive_Letter()
On Error Resume Next
Set AWF = Application.WorksheetFunction
For Each HL In ActiveSheet.Hyperlinks
HL.Address = AWF.Substitute(HL.Address, "O:\", "C:\")
Next
End Sub
==============
והמשך/×™, × ×, ×œ×§×¨×•× ×ת השורה הב××”:
***********
×× ×ª×’×•×‘×ª×™ עזרה לחץ/×™, × ×, על <כן> בפס ×”×ופקי התחתון!
***********
מיכ×ל ×בידן
מנהל ×¤×•×¨×•× "×ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top