Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

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

08 Feb 2016   #1

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

My System SpecsSystem Spec
08 Feb 2016   #2

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)

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 System SpecsSystem Spec
08 Feb 2016   #3

Windows 7 Ultimate, Service Pack 1, 64 bit

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 System SpecsSystem Spec

09 Feb 2016   #4

windows 7
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 System SpecsSystem Spec

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

Thread Tools

Similar help and support threads
Thread Forum
It should open an excel sheet after pressing Ctrl+alt+del
I am a team lead and want to track the activities of my subordinate I want every time when he press Ctrl+alt+del an excel sheet should open and he should write a reason why he locked his should not work further without adding a comment in excel sheet.
Microsoft Office
How do I copy Most Visited File/Document shortcuts to an Excel sheet ?
I would like to be able to copy onto an Excel sheet the Most Visited file/document shortcuts. I'm not referring to any internet shortcuts/bookmarks. The list of Most Recent files visited can be seen at: C:\Users\\AppData\Roaming\Microsoft\Windows\Recent But I'm just looking to...
General Discussion
Excel 2013 Opening Size of Sheet
First, I always close sheets in the position and size that I want them to open in. However, with my new Office 2013, when I open a sheet, or even first open Excel and it comes up with a new sheet, it's opens in a small window and the window is positioned in the left lower quadrant of my screen,...
Microsoft Office
Printing Excel-sheet
Hi, I recently began learning Office 2010 and have an Excel specific question. The thing is, when I print an Excel-file I prepared the print is real tiny, almost unreadable as if the sheet should be divided into 6 or 7 pages rather than the 3 pages that I have somehow managed to get it down to. It...
Microsoft Office
Want to copy data and formula from one Excel Sheet to another.
I have a budget workbook set up in Excel, and in that workbook there are many different sheets all part of the one book. I have created a formula in one sheet from the data that is collected there, and that data is important for information collected on another sheet. I want to copy the...
Microsoft Office

Our Sites

Site Links

About Us

Find 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 12:26.
Twitter Facebook Google+