How to define this workbook and active workbook

[amkumar]

Hello,

i need some coding in VBA which can define this workbook & active workbook in any example.


Thanks
Amit

 

[Michael M]

Does this thread help ???

https://www.mrexcel.com/forum/excel-questions/985315-thisworkbook-vs-activeworkbook.html

 

[amkumar]

thnx for this but this thread is not help properly.

 

[Michael M]

In that case you need to explain to us what you actually want to know !

 

[Norie]

Amit

You don't need to define ThisWorkbook and ActiveWorkbook, they already exist.

ThisWorkbook refers to the workbook the code is in and ActiveWorkbook refers to the currently active workbook.

 

[Michael M]

Unless, of course you need....

dim Wb as workbook
Set Wb=Thisworkbook
OR
Set Wb=activeworkbook

 

[DanteAmor]

An example:

Sub test()
    Dim wb1 As Workbook, wb2 As Workbook
    Workbooks.Open "file1.xlsx"
    Set wb1 = ActiveWorkbook    'The wb1 object is established in the active book (it is the recently opened book)
    
    Set wb2 = ThisWorkbook      'It does not matter which book is active, in the object wb2 the book that contains this macro is established.
    
End Sub