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
| Private Sub Commande10_Click()
Dim xlapp As Excel.Application
Dim stDocName As String
Dim xlsheet As Excel.Worksheet
Dim excelsheet As Object
Dim xlbook As Excel.Workbooks
Dim cell As Excel.Range
'j'exporte mon premier état nommé circu
stDocName = "circu"
Set xlapp = CreateObject("Excel.Application")
With xlapp.Application
.Visible = False
.Workbooks.Open ("C:\Documents and Settings\adus145\Application Data\Microsoft\Excel\XLSTART\perso.xls")
End With
DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, "", True
xlapp.Application.Run ("PERSO.xls!MEF")
Set xlapp = Nothing
Set xlbook = Nothing
End Sub |
Partager