File Exists 1

[Guest]

Thanks, but I need to know if the workbook name that is open is the the last
one in the file or if it is one of the earlier ones. For instance if I have 5
workbooks in the folder I need to know if the workbook is Myfile 4 then I
need to disable a button on the userform that allows them to create another
workbook whereas if Myfile 5 is open then the button on the userform will be
enabled so they create a new workbook.

 

[Guest]

jnf40,

Do you want to check for exactly 5 files in a particular folder? Is this a
shared workbook?

 

[Guest]

Thanks for the question, I have been gone. No there can be numerous files in
this folder, and the folder will only be accessed by one person at a time.