Solved

Exporting website addresses  from Excel to Internet Explorer Favorites folder

Posted on 2006-11-08
2
207 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 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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

724 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