Hello,

I have a problem with a workbook wich runs fine with Excel 2003 and Excel 2007.
With Excel 2010 :

in private sub Workbook_open()

the instruction myPath=ActiveWorkbook.Path failes, in the debug mode, in the excecution window, il I put ? ActiveWorkbook.Path or ? ActiveWorkbook.name, I receive an error.

I tried to redirect the sub in another one in modules, but same problem.

I can imagine there is a security control but this file has just very few modification from the same I created last year, on the old one is ok and the new one doesn't work ....

Thank you for an idea to test

Launas