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
deerfield

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
strollin

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
Lance1

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
deerfield

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
Reply

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




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
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
Update (copy) file to multiple places in directory structure
I have a directory structure root 1 sida 0002-A.xlp 2 sida 0002-A.xlp ...
General Discussion
problem saving excel spread sheet in 2010 to 97-2003 format
I have an new style Excel xlsx spreadsheet that I received from a customer through Email and I can open and re-save as an xlsx spreadsheet using excel 2010. I have saved it to my desktop. When I try to save it in the 97-2003 xls format. Excel then crashes right away and a window pops up. Microsoft...
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 07:50.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App