recent files

In excel by pressing Ctrl-O, I can see the open dialog with two tabs "recent" and "pinned". if I right click on any item in them, I can see "open" and "open a copy", but no open readonly. To open read-only I have to click browse and navigate to the right folder, locate the file and there is the...

Would be very grateful to anyone who can provide assistance. I use a program that exports data to an xlsx file in a particular directory. The code below will open the most recent file in the hardcoded directory. Sub NewestFile() Dim MyPath As String Dim MyFile As String Dim...

I am trying to add a filter to only select the most recent file to import, but am stuck. Does anyone know how to achieve this? Sub opname1() Const toFind = ".log" Dim vpath As String Dim vfile As String Dim curTxt As Workbook vpath = "C:\Users\test\Desktop\test"...

When I click on the File tab, a bunch of recently opened files are listed above the Info tab. That tab is greyed out. I can't remove this list or the items in it. Anyone else have this issue? The firewall at work won't allow me to use any of the image attachment widgets.

This is not vb just plain EXCEL. I recently had to replace my hard drive and re-install my software and needless to say there are so many minor things I am trying to resolve. My list of Recent Files seems to frequently disappear. I know when I reboot / restart that the list has gone but I...