macro to set current workbook as variable and set as active later

[theath]

I need help with a macro. When I run the macro, I need to set the current workbook as a variable. I want to then call that variable later.


Here is what I have and it doesn't work. I have two workbooks open. If I name them in the macro I can see it switc focus to each one. If I try to pass in a variable name, I get errors. Any ideas?


Sub switchWorkbook()


Dim WB As Workbook

Set WB = ThisWorkbook


Windows("FEB PROJECT REPORT.CSV").Activate


Windows(WB).Activate


End Sub

 

[Hui]

Theath


The currentworkbook is

Activeworkbook.Name

 

[theath]

Wow, that was simple! Thanks for the help. I added this to the full script I was working on and it works like a charm!!


Thanks Hui!

 

[kchiba]

Hi,


You could have said WB.Activate instead of Windows(WB).Activate