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?
Workbook.ActiveSheet returns an Object
Sheets accepts a String
Any suggestions?