How to Create an Excel File Using Visual Basic 6.0. ... Set tBook = oExcel.Workbooks.Add 'Create an array with 3 columns and 50 rows. You create an array fewer or more columns and rows as needed.