Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2017, 05:16 PM
skarden skarden is offline VBA to Display Recent Files in Backstage Windows Vista VBA to Display Recent Files in Backstage Office 2010 64bit
Novice
VBA to Display Recent Files in Backstage
 
Join Date: Dec 2011
Location: Orlando, FL
Posts: 26
skarden is on a distinguished road
Question VBA to Display Recent Files in Backstage

I just got Office 2016 after moving from Office 2010 and don't like the new look, especially the Recent Files icon, that when on the QAT, looks like a folder with a squished bug on it. So, I wanted to roll my own. I've got everything set up, but for the life of me I can't find the VBA that will show the Recent Files in the Backstage.

My other idea was to change the icon myself, but apparently, when you use one of the built ins in the XML to program the QAT, i.e., idMso="FileOpenRecentFile", you can't change the icon.



Does anyone know VBA that would give me the same result as using the idMso="FileOpenRecentFile" or know how to change its icon?

Thanks,

Stuart
Reply With Quote
  #2  
Old 05-04-2017, 09:19 PM
gmayor's Avatar
gmayor gmayor is offline VBA to Display Recent Files in Backstage Windows 10 VBA to Display Recent Files in Backstage Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

See http://gregmaxey.com/word_tip_pages/...mage_text.html
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 05-06-2017, 04:42 AM
skarden skarden is offline VBA to Display Recent Files in Backstage Windows Vista VBA to Display Recent Files in Backstage Office 2010 64bit
Novice
VBA to Display Recent Files in Backstage
 
Join Date: Dec 2011
Location: Orlando, FL
Posts: 26
skarden is on a distinguished road
Smile Macro to go to Recent Files Opened

That's for the reply, but I'm not sure that would let me designate my own icon for a built in, idMso, call. However, it is moot as I *finally* found the way to go to the Recent Files Open screen in the Backstage. (It worked in Word 2016 and I haven't tried it on earlier versions).

The single program line I needed was:

Application.CommandBars.ExecuteMso ("FileOpenRecentFile")

then it was a snap for me create a macro with that line in it, use my own icon and to execute it via a standard Ribbon callback called from my custom button.

Stuart
Reply With Quote
Reply

Tags
recent file, ribbon, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to Display Recent Files in Backstage Recent files list not showing in Word or Excel Flobiwan Office 2 04-22-2017 10:28 AM
The powerpoint icon on the task bar hides pptx files in the recent files list Innovationgame PowerPoint 0 11-13-2013 09:03 AM
VBA to Display Recent Files in Backstage Opening Word /Excel reinstalls files, loses recent files adj1 Office 3 05-10-2013 12:27 AM
VBA to Display Recent Files in Backstage Can't see my recent files avner09 Excel 5 07-26-2011 12:58 AM
Recent file display option at MS word Patrick Lau Word 0 08-16-2010 11:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft