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


  1. Posts : 2
    windows 7
       #1

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


    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 ?
    Last edited by deerfield; 08 Feb 2016 at 14:57. Reason: forgot to put in spaces between sentences
      My Computer


  2. Posts : 3,371
    W10 Pro desktop, W11 laptop, W11 Pro tablet (all 64-bit)
       #2

    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.
      My Computer


  3. Posts : 630
    Windows 10 Pro 64 bit
       #3

    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
      My Computer


  4. Posts : 2
    windows 7
    Thread Starter
       #4

    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.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 00:43.
Find Us