PDA

View Full Version : How do I copy Internet Most Visited Places shortcuts to an Excel sheet ?



deerfield
02-04-2016, 09:50 AM
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 Explorer


Press 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 tab


Select 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 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 ?