I'm running Excel 2000 in Win 98Se. When the user selects "File|Open" in Excel,
the Open dislog box displays several locations for possible files. One of the
locations is Excel's "History" folder. This folder contains links to files opened
previously opened in Excel.
In Win 98Se, the path of this folder is
"C:\WINDOWS\Application Data\Microsoft\Office\Recent".
Clicking on "Recent" in the dialog box, one can see the path.
Examining the structure of the path in Win 98, one finds the "links" in the "Recent" folder.
In Xp, the path is different, yet similar because the files are in the path
"C:\ [varies] \Application Data\Microsoft\Office\Recent".
This is the "default path" I would like to know. Something simple,
like "a = Application.HistoryPath" or "a = Application.RecentPath".
Currently, I am having to use the "default template path" along with string
length and left string functions to create a path to this "History" folder. The code is displayed below.
a = Application.TemplatesPath
b = Len(a) - 10
a = Left(a, b)
a = a & "Office\Recent\*.lnk"
Kill a
Thanks,
JH