Tutorial by Examples

This code uses the top level Application object to minimize the main Excel window. Sub MinimizeExcel() Application.WindowState = xlMinimized End Sub

Sub DisplayExcelVersions() MsgBox "The version of Excel is " & Application.Version MsgBox "The version of the VBE is " & Application.VBE.Version End Sub The use of the Application.Version property is useful for ensuring code only operates on a compatible...