Application VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Application
  4. Use the Application object qualifier to set properties
Sub appProperty()
    Application.Calculation = xlManual
    Application.EditDirectlyInCell = False
    Application.DefaultFilePath = "C:\My Documents"
    
End Sub