Solved How do I copy Internet Most Visited Places shortcuts to an Excel sheet

[deerfield]

I would like to be able to copy onto an Excel sheet my Internet Explorer Most Visited Places Shortcuts, NOT all history or recent places shortcuts.

You can view your internet Most Visited Places Shortcuts by:Get into Internet ExplorerPress Control H (which should bring up the Favorite-Feeds-History menu… or else press Control H a second time to get it)

Select the History tabSelect the down arrow under History and select "View by Most Visited"This will bring up the Internet Most Visited Places Shortcuts menu, which contains a list of the website places a person has visited the most.

From here you can also see the number of times you have visited a single shortcut by right clicking a shortcut, select Properties, and look at the Most Visited number I want to learn how to and also if possible get VBA code to copy these most visited shortcuts, say the most visited 50 or as many up to that as I can get, to an Excel sheet.

Please note that…I know that I can find internet History shortcuts at:C:\Users\[Owner Name]\AppData\Local\Microsoft\Windows\History
And can find internet Most Recent shortcuts (favorites) at:C:\Users\[Owner Name]\AppData\Roaming\Microsoft\Windows\Recent

But I do not want to find and copy all history shortcuts or just most recent shortcuts… I want to find and copy the most visited shortcuts.

Does anyone know how to do this ?

 

[strollin]

Are you asking how to copy them all at once? I don't know how to do that but you can copy them one at a time by right-clicking and selecting Properties, within the Properties dialog is the link which you can then copy/paste into an Excel spreadsheet.

 

[Lance1]

Hi deerfield and welcome to WSF. This program will do what your looking for, I think anyway. I downloaded it and tested it and it saves selected URL's to XML.

IEHistoryView v1.70

 

[deerfield]

Thank you guys...

Thank you Strollin... yes, I was trying to find a way to copy all of the most visited menu shortcuts all at once but it seems that there is not a way to do that.

And yes, I was aware of that way to copy them one at a time but that will only copy a single link destination and not the link title too. And I was looking for any automated way through VBA to copy them all at once into an Excel sheet. Thank you for the response.

Thank you Lance1 for the info on that freeware program. I don't think it provides what I'm looking for, which is just the most visited links, it instead provides all links history. The most visited links menu list is likely derived from the history file of links. Just knowing about that file and the program you've indicated is useful to me for other uses too however. o hank you very much Lance1.