Retieve Workbook Name via code
 

Is there some code that will retrieve a workbook name?

What I'm trying to do within some code (in an xl template) is to activate
the workbook again after the procedure has done some activity in another
workbook. But the workbook that has the code in it doesn't always have the
same name.

Rob

Retieve Workbook Name via code
 

Thisworkbook.Activate


"RobN" wrote:

Is there some code that will retrieve a workbook name?

What I'm trying to do within some code (in an xl template) is to activate
the workbook again after the procedure has done some activity in another
workbook. But the workbook that has the code in it doesn't always have the
same name.

Rob

Retieve Workbook Name via code
 

Thanks JMB....so simple!

Rob

"JMB" wrote in message
...
Thisworkbook.Activate


"RobN" wrote:

Is there some code that will retrieve a workbook name?

What I'm trying to do within some code (in an xl template) is to activate
the workbook again after the procedure has done some activity in another
workbook. But the workbook that has the code in it doesn't always have
the
same name.

Rob