Solved

Exporting website addresses  from Excel to Internet Explorer Favorites folder

Posted on 2006-11-08
2
195 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
2 Comments
 
LVL 29

Accepted Solution

by:
matrixnz earned 500 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Ok I have been working on this for some time having learned and gained certification in XenDesktop 4 along came version 5 which was released last month. Since then I have been working to deploy XenDesktop 5 in a small environment with only 2 virt…
cPanel is a Unix based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web site. cPanel utilizes a 3 tier structure that provides functionality for administrators, rese…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
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…

786 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