How get data into IE6 as "Favorites"?

[George]

I'm using MS Excel 2003, and have a simple line-item list of websites in a
spreadsheet. Is there a way to somehow explort, convert, link, or whatever
these so they show up in "Favorites" in Internet Explorer--like in the below
example. I have way too many to key these in manually in IE6. Even better,
is there a way to have IE6 "look" into Excel or even into Access (I could
move the data into Access) and have the links pop up as choices in Favorites
in IE6.
Thanks,
George

EXCEL:
Here's a sample from my Excel spreadsheet:
1800mobiles.com www.1800mobiles.com
Aastra (was Nortel products) www.aastra.com
AbleComm www.ablecomm.com
Adorama www.adorama.com
Advanced Furniture www.afo.com
Advantage Laser Products www.advlaser.com


MS IE6:
Here's what I'd like to see in "Favorites" In IE6 as hot links:
( ) 1800mobiles.com
( ) Aastra (was...)
( ) AbleComm
( ) Adorama
etc.

 

[PaulD]

: I'm using MS Excel 2003, and have a simple line-item list of websites in a
: spreadsheet. Is there a way to somehow explort, convert, link, or
whatever
: these so they show up in "Favorites" in Internet Explorer--like in the
below
: example. I have way too many to key these in manually in IE6. Even
better,
: is there a way to have IE6 "look" into Excel or even into Access (I could
: move the data into Access) and have the links pop up as choices in
Favorites
: in IE6.
: Thanks,
: George
:
: EXCEL:
: Here's a sample from my Excel spreadsheet:
: 1800mobiles.com www.1800mobiles.com
: Aastra (was Nortel products) www.aastra.com
: AbleComm www.ablecomm.com
: Adorama www.adorama.com
: Advanced Furniture www.afo.com
: Advantage Laser Products www.advlaser.com
:
:
: MS IE6:
: Here's what I'd like to see in "Favorites" In IE6 as hot links:
: ( ) 1800mobiles.com
: ( ) Aastra (was...)
: ( ) AbleComm
: ( ) Adorama
: etc.
:

You could easily export these using a macro. Don't have the time to write
this for you, but here is how to do it.
your favorites are stored under documents and settings in a favorites
folder. Shortcuts for IE are just text files with a .url extension. the
text in them needs to be

[InternetShortcut]
URL=www.domain.com

So one approach method would be to loop through each cell, look for the www.
then strip off everything to left for the file name, then use the www. for
the 'URL=' part. There are a couple of ways to create text files that will
work, just make sure to create each file in your favorites folder. Maybe
someone will post the code for you or you can give this a shot yourself and
if you need more help post back
Paul D

 

[Guest]

This worked for me assuming your data is in column A with a heading in the
first row.

Sub AddFavs()

Dim favPath As String
Dim endRow As Long
Dim flName As String
Dim Url As String
Dim counter As Long
Dim FileNumber As Integer

favPath = "C:\Documents and Settings\" & _
Environ("USERNAME") & "\Favorites\"

endRow = Cells(Rows.Count, 1).End(xlUp).Row
For counter = 2 To endRow
FileNumber = FreeFile
flName = Left(Cells(counter, 1).Value, _
InStr(1, Cells(counter, 1).Value, "www") - 2) & ".url"
Url = Right(Cells(counter, 1).Value, _
Len(Cells(counter, 1).Value) - _
InStr(1, Cells(counter, 1).Value, "www") + 1)
Open favPath & flName For Output As #FileNumber
Print #FileNumber, "[InternetShortcut]"
Print #FileNumber, "URL=" & Url
Close #FileNumber

Next counter

End Sub


Hope this helps
Rowan

 

[PaulD]

: I'm using MS Excel 2003, and have a simple line-item list of websites in a
: spreadsheet. Is there a way to somehow explort, convert, link, or
whatever
: these so they show up in "Favorites" in Internet Explorer--like in the
below
: example. I have way too many to key these in manually in IE6. Even
better,
: is there a way to have IE6 "look" into Excel or even into Access (I could
: move the data into Access) and have the links pop up as choices in
Favorites
: in IE6.
: Thanks,
: George
:
: EXCEL:
: Here's a sample from my Excel spreadsheet:
: 1800mobiles.com www.1800mobiles.com
: Aastra (was Nortel products) www.aastra.com
: AbleComm www.ablecomm.com
: Adorama www.adorama.com
: Advanced Furniture www.afo.com
: Advantage Laser Products www.advlaser.com
:
:
: MS IE6:
: Here's what I'd like to see in "Favorites" In IE6 as hot links:
: ( ) 1800mobiles.com
: ( ) Aastra (was...)
: ( ) AbleComm
: ( ) Adorama
: etc.
:

If it was possible to have the name in column A, and the hyperlink in column
B, then this little routine does the trick. This assumes the hyperlink in
column B is a true hyperlink and not just text.

Public Sub AddLinks()
Dim h As Hyperlink
Dim myLink As Hyperlink

For Each h In ActiveSheet.Hyperlinks
Set myLink = h
myLink.TextToDisplay = myLink.Range.Offset(0, -1).Value
myLink.AddToFavorites
Next h
End Sub

 

[George]

Thanks, this is a great idea (although I haven't done macros in Excel
before, is there a 5-minute tutorial anywhere?)

Also, is there any way to "manage" IDs and passwords for each link... In
IE6, I have the links bar at the top of monitor, and see this:

Links
Shopping>
Amazon
Buy.com
eBay
(Others)>

Is there a "any" way to "securely" put ID/PW in each somehow, so I don't
have to manually look up (and I don't have to use the "remember me" thing at
every site), like this:

Links
Shopping>
Amazon [email protected] pw=1234567
Buy.com [email protected] pw=1234567
eBay [email protected] pw=1234567
(Others)>

(Yes, I know you don't generally paste in ID/PWs everywhere, but bottom line
is I'm trying to find a way to integrate this info into the browser, to ease
everyday use, but still be secure....and not add still another application
like a password manager or something to the PC....although can if I have to)
so, thanks for any ideas