PC Review


Reply
Thread Tools Rate Thread

add the urls in column a to ie favorites

 
 
Max Bialystock
Guest
Posts: n/a
 
      13th Nov 2006
Is there a way to add the urls in column a to ie favorites?



 
Reply With Quote
 
 
 
 
Michel Pierron
Guest
Posts: n/a
 
      13th Nov 2006
Hi Max,
Something like:

Sub UpdateFavorites()
Dim sFolder As String
sFolder = CreateObject("WScript.Shell").SpecialFolders("Favorites")
Dim sFile$, sLink$, f&, p%, i%: i = 1
With ThisWorkbook.Sheets(1)
Do While .Cells(i, 1) <> ""
sLink = Mid$(.Cells(i, 1), 8)
p = InStr(1, sLink, "www.", 1)
If p Then sLink = Mid$(sLink, p + 4)
sLink = Mid$(sLink, 1, InStr(1, sLink, ".") - 1)
sFile = sFolder & "\" & sLink & ".url"
f = FreeFile
Open sFile For Output As #f
Print #f, "[InternetShortcut]"
Print #f, "URL=" & .Cells(i, 1)
Close #f
i = i + 1
Loop
End With
End Sub

MP

"Max Bialystock" <(E-Mail Removed)> a écrit dans le message de news:
%(E-Mail Removed)...
> Is there a way to add the urls in column a to ie favorites?
>
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Corrupt Favorites,urls DL Windows XP Internet Explorer 12 12th Nov 2006 02:19 PM
How can I copy and print URLs from Favorites? =?Utf-8?B?bWFuZm9yMzM=?= Microsoft Word Document Management 1 19th May 2006 03:09 PM
Listing URLs of Favorites? Fav Curious Windows XP Internet Explorer 1 29th Jun 2004 11:05 PM
urls from favorites koolking Windows XP Internet Explorer 1 25th May 2004 09:59 AM
saving favorites urls Sue Windows XP General 1 19th May 2004 11:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:40 AM.