Vb erreu rouverture excel
cs_Le Pivert Messages postés 7904 Date d'inscription Statut Contributeur Dernière intervention -
Bonjour,
Public Class Form1
Private Sub Form1_Initialize()
Dim xlpp As Object
Dim xlSheet As Object
Dim xlWorkBook As Object
xlApp = CreateObject("Application Excel")
xlWorkBook = xlApp.Workbooks.Open(Filename:="d:\retraite\retraite de Georges LAMBERT.xlsm")
xlSheet = xlWorkBook.Sheets("Données principales")
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
With xlApp
'.EnableEvents = False
'.Application.Visible = False
'.DisplayAlerts = False
End With
'xlApp.Visible = True
'xlSheet.activate
Dim msgBoxResult = MsgBox(xlSheet.Range("A1").value)
End Sub
Windows / Chrome 108.0.0.0
- Vb erreu rouverture excel
- Liste déroulante excel - Guide
- Word et excel gratuit - Guide
- Déplacer colonne excel - Guide
- Si ou excel - Guide
- Excel moyenne - Guide
2 réponses
bonjour,
merci de tenir compte de ceci quand tu partages du code: https://codes-sources.commentcamarche.net/faq/11288-poster-un-extrait-de-code