?
Solved

Exporting website addresses  from Excel to Internet Explorer Favorites folder

Posted on 2006-11-08
2
Medium Priority
?
214 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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Disclosure: Use this tutorial only when no other options helps to get Windows XP running without any problems and you don't want to format the drive. The back up of the data is the responsible of the user, however there is a description of how t…
If you build your web application in Visual Studio you'll get at least a few binaries, or .DLL, files in your bin folder. However, there is more compiling to be done. Normally this would happen when an ASP.NET resource within the web site is request…
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses

801 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