Improve company productivity with a Business Account.Sign Up

x
?
Solved

Exporting website addresses  from Excel to Internet Explorer Favorites folder

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If your system is showing symptoms of browser hijacks or 'google search redirects' check out my other article (http://rdsrc.us/u3GP7A) first and run the tool TDSSKiller (http://rdsrc.us/GDBBs4) to get rid of the infection. Once done, and if the …
Nuance's PaperPort may display this error message: PaperPort appears to be running Windows XP Compatibility Mode which may result in errors. We recommend disabling Compatibility Mode for the PaprPort.exe program, see Technote 6629. This articl…
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…
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…

606 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