Other than ActiveWorkbook and ThisWorkbook

[BBCC0000]

Hi all!!

I want to ask other than ActiveWorkbook.Sheets and ThisWorkbook.Sheets, does it have other functions similar to this?

As I want to automate the process using a button but the workbook is under ActiveWorkbook, which means I have to open that active workbook to run the code.

Any function that can run when the active page is under ThisWorkbook?

 

[jolivanes]

If I understand your requirement right, look at using With...... End With and ensure you use periods where required.

 

[Tupe77]

I probably didn't understand your question right, but is your question about selecting a workbook?
VBA can be used to define the workbook to be used in at least the following ways:

ThisWorkbook: Refers to the workbook itself. (VBA code is stored in this file)
ActiveWorkbook: Refers to the active workbook.
Workbooks(1): Refer to workbook by index.
Workbooks("September_2023.xlsm): Refer to workbook by file name.