sPath = Activeworkbook.Path

--
Regards,
Tom Ogilvy

"monir" wrote in message
...
In a VBA Excel macro, how can I identify the full path of "this" opened
workbook test1.xls, and then use it to open another file test2.xls at the
same location ?

Will the procedure change the current folder in the File menu ?

Thank you.