"George" wrote in message
...
: 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