Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Declare a Workbook object variable and assign the ActiveWorkbook object to it, so that subsequent code can work with the object vari
Sub workbook()
    Dim myWorkbook As Workbooks
    Set myWorkbook = ActiveWorkbook
    With myWorkbook
        'actions here
    End With
End Sub