Hi,

I have an Excel book with an auto_open macro. To determine the directory of this Excel File I have used the CurDir() function. It works correctly when the Excel file is the only one which is opened. It also works correctly when there are other Excel files without macros opened. But if there is another file containing macros opened, CurDir supplies the directory of the other file.

I need a robust method to determine the directory of the Excel file. Could anyone please help me?

Thanks,