I am designing a macro to look in a file and if there is only one XL workbook, to open the file. What would be the best way to do this? I tried using
Code:
Worbooks.Open("*.xls")
and a few variations on that, but it dosen't seem to work.
Thanks for any help you got.