Add open file to last files opened on Menu
I am opening files from within an excel workbook:
Note: vOPen and vPassword are hard coded in the workbook and I save the
cell values to the variables and then on before double click I do this to
open the selected file:
Workbooks.Open Filename:=vOpen, Password:=vPassword, UpdateLinks:=3
The issue is the opened file is not added to the most recent opened under
Files on the Menu. Is there code that would add the file to the list?
Thanks for your help.
Steven
|