What do you mean by "last workbook": based on create date, modified
date, filename.... ?

Tim.


"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