1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
Private Sub Option1_Click()
Dim XelApp As Object ' Aplication
Dim XelWorkSheet As Object ' Feuille Calcul
' Set Sheet1.Container = XelWorkSheet
Dim XelStillRunning As Boolean
'Sheets(1).SetFocus
' Set Sheet1 = DataObject
On Error Resume Next
Set XelApp = GetObject(, "Excel.Application")
If Err.Number <> 0 Then
Set XelApp = CreateObject("excel.application")
XelStillRunning = False
Else
XelStillRunning = True ' Excel déja Ouvert
End If
On Error GoTo 0
'Sheets(1).Visible = True
XelApp.Workbooks.Add
XelApp.Visible = True
Set XelWorkSheet = XelApp.ActiveSheet
XelWorkSheet.Cells(1, 1).Value = " Bravo Alison"
XelWorkSheet.Cells(1, 1).Value = Replace("Alison", "Ali", "Jea") ' ************************************
XelWorkSheet.Visible = True
' Set Me.Sheet1.Object = GetObject(, "XelApp.xelworksheet") ' 'GetObject(, "excelsheet")
' Sheet1.Object = XelWorkSheet
XelWorkSheet.SaveAs ("c:\data\xeldata\XlBravo.xls"), True
If Not (XelStillRunning) Then XelApp.Quit
End Sub |
Partager