Thisworkbook refers to the workbook where the executing code is located.

Activeworkbook is the workbook that has the focus in the Excel application.

--
Regards,
Tom Ogilvy

"windsurferLA" wrote in message
...
Tom Ogilvy suggested

Activeworkbook.FullName

I've also seen suggestion to use the object

"thisworkbook."

what is the difference between "thisworkbook." and "activeworkbook." ???

WindsurferLA