VBA Workbooks.activate default

[jakobt]

Created a macro to define a variable for the current activated workbook. Then I open another file. And then I want to activate the first workbook. The code defaults when cworkbook is asked to be activated in the end of the code:


Sub This_Workbook()
'Reference to active work book


Dim cWorkbook As Workbook


Set cWorkbook = activeworkbook


Debug.Print cWorkbook.Name


Workbooks.Open ("S:\TB\UK TB_MTD_0918-en-us.xlsx")


Workbooks(cWorkbook).Activate




End Sub

 

[offthelip]

I swap between the existing workbook and a new workbook using this code:

CurrentWorkbookName = ActiveWorkbook.Name
Workbooks.Add
NewWorkbookName = ActiveWorkbook.Name
' do something in the the new workbok


Workbooks(CurrentWorkbookName).Activate
' swap back to the orginal workbook

 

[MARK858]

jakobt, what happens in your original code if you change

Workbooks(cWorkbook).Activate

to

cWorkbook.Activate