-
Hy, everyone. I´m trying to show on my Standard form the format cells of Excel(locate into an Excel cell and then push Ctrl+1), I'm using an ole from VB to Excel like this:
'********** I M P O R T A N T
'********** U must have to go to the project references and select the Microsoft Excel 9.0 or 8.0 Object Library
'----------- VB code
Option Explicit
Dim xlsApp As Excel.Application
Private Sub Command1_Click()
Set xlsApp = Excel.Application
With xlsApp
'Show Excel
.Visible = True
'Create a new workbook
.Workbooks.Add
'Put text in to the cell that is selected
.ActiveCell.Value = "123"
'Put text into A3 regardless of the selected cell
.Range("A3").Value = "456"
'----------- VB code
My question is: How can i show the format cells that appears in Excell
Thanx everyone
-
do you mean how to format what the cells look like?
