Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

The Workbooks property is a member of the Application object and returns a reference to the Workbook object specified by the index v

Sub changePro()     Workbooks(1).Windows(1).WindowState = xlNormal     Workbooks(1).Windows(1).Width = 500     Workbooks(1).Windows(1).Height = 300 End Sub