?
Solved

Exporting website addresses  from Excel to Internet Explorer Favorites folder

Posted on 2006-11-08
2
Medium Priority
?
219 Views
Last Modified: 2012-06-27
I have several hundred websites stored in Excel.
How can I import them into my Favorites folder in IE?

I tried saving as HTML, TXT and then using the IE import wizard, but received message "Invalid bookmark format"

Thanks!
0
Comment
Question by:tomfolinsbee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
matrixnz earned 2000 total points
ID: 17904489
This is a bit backwards but it should work

1. Export current favorites to bookmark.htm
2. Using Excels concatenate function to create your bookmark page entries
For e.g.

Column A                                                          Column D
<p><DT><A HREF="

Column B
http://www.yourlinks.com

Column C
" ADD_DATE="1161831623" LAST_VISIT="1163052851" LAST_MODIFIED="1161831624">

Column D
=B1&"</A>

Column E
=A1&B1&C1&D1

Select Column A and drag to the bottom of your list this should now drag Column C, D and E to the bottom of your list as well
Once completed copy Column E into the Bookmark.htm file between the header and footer.  I hope you get what I mean and hope that helps.

Cheers
0
 

Author Comment

by:tomfolinsbee
ID: 17985076
Sorry for the delay and thanks a lot for the solution - worked like a charm!
-Tom
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you unable to synchronize your OST (Offline Storage Table) file with Microsoft Exchange Server? Is your OST file exceeding 2 GB size limit? In Microsoft Outlook 2002 and earlier versions, there is a 2 GB size limit for the OST file. If the file …
Migration of Exchange mailbox can be done with the ExProfre.exe tool. But at times, when the ExProfre.exe tool migrates the Exchange Server user profile, it results in numerous synchronization problems. Synchronization error messages appear in the e…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question