Creating Excel Spreadsheets

[CHarris]

How would I create an Excel spreadsheet and save it to a file within VB?

Thanks,

COrey

[Iouri]

Dim ApExcel As Object 'To open Excel

Set ApExcel = CreateObject("Excel.application") 'Creates an object
ApExcel.Visible = True ' So you can see Excel
ApExcel.Workbooks.Add 'Adds a new book.
ApExcel.cells(1, 1).Formula = "HELLO" 'Add Text to a Cell
'You can use the line above, changing coordenates to go to any
'cell and you can also add Formulas
ApExcel.Range("A1:Z1").BORDERS.Color = RGB(0, 0, 0) 'Use it to
'change the borders.
ApExcel.Columns("A:AY").EntireColumn.AutoFit 'To adjust the
'column's width.
ApExcel.Range("A:Z").Select 'To establish a selection
ApExcel.Selection.NumberFormat = "0" 'Adding different formats


Iouri Boutchkine
[email protected]

[Iouri]

To save
xlapp.activeworksheet.SaveAs "C:\Whatever"



Iouri Boutchkine
[email protected]