Worksheet Names 1

[mcm103]

I am working with two Excel workbooks which have the same worksheet names. I want to dynamically capture the name of the active worksheet and use that name to open the cooresponding worksheet on the other workbook.

Workbook.ActiveSheet returns an Object
Sheets accepts a String

Any suggestions?

 

[RobHudson]

Is it not ActiveSheet.Name ??
Or am I off down the wrong path all together!

 

[mcm103]

Thats it, Thanks