Saving an IE Favorite from an Excel macro

  • Thread starter Thread starter mvelez3
  • Start date Start date
M

mvelez3

I'm trying to write some code that will do various tasks as part of
new system implementation. The code needs to run on many PCs wit
various combinations of software installed.

Originally I thought of using VBA in Ms Access to do it and I wrot
code that worked fine. But not all PCs have Access installed. Now I'
thinking of doing with Excel (as all PCs should have Ms Office St
installed).

One of the tasks is to save in the IE "Favorites" folder a favorite t
a particular hyperlink address. In Access I used th
"HyperLink.AddToFavorites" method and it worked just fine. It doesn'
seem to work in Excel.

The address I'm trying to save goes something like this
"http://server.network.net:7781/forms90/f90servlet?config=bfoc&form=issz003.fmx"
Does anyone know how I could do this?

I need not just the code to access the Favorites folder but also th
code to add the new Favorite
 
Try something like the following

Dim HL As Hyperlink
Dim WS As Worksheet
Set WS = ActiveSheet
Set HL = WS.Hyperlinks.Add(Range("A1"),
"http://www.cpearson.com", , , "Pearson")
HL.AddToFavorites
HL.Delete
Range("A1").Clear


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top