If it is in a folder and not open in Excel, then it will not be in the
workbooks collection.

Define what makes a file the last workbook in a folder. Alphabetically, by
the date it was saved, ??

--
Regards,
Tom Ogilvy


"teresa" wrote in message
...
Hi,

Which command do I use to locate the last workbook in A Folder
so e.g. My Documents
So Far I have

sub fold()

dim i

i = C:\My Documents\Workbooks.Count
MsgBox C:\My Documents\Workbooks(i)

End Sub