set to activeworkbook name

[MetLife]

Hi,

I want to set a string variable to the workbook name.

Dim MainWkbook as string
Set MainWkbook = ThisWorkbook
Windows(MainWkbook).Activate

This does not work?

 

[Joe4]

"Set" is only used when setting Objects, not Strings.
You need to declare it as a Workbook object.

Try this:

Dim MainWkbook As Workbook
Set MainWkbook = ThisWorkbook
MainWkbook.Activate