Public oApp As Object Public workbookExcel As Object Public sheetExcel As Object Private Sub Macro() ' Fichier créé uniquement en vue de gérer les erreurs éventuelles Dim oAppError As Object Set oAppError = CreateObject("Excel.Application") 'Objects creation Set oApp = CreateObject("Excel.Application") oApp.Visible = False ' Set workbook worksheet Set workbookExcel = oApp.workbooks.Open(C:\Datas.xls") Set sheetExcel = workbookExcel.sheets("Sheet1") ' Launch the UserForm UserForm1.Show 'Close the workbook workbookExcel.Close oApp.Quit Set sheetExcel = Nothing Set workbookExcel = Nothing Set oApp = Nothing End Sub
'Objects creation Set oApp = CreateObject("Excel.Application") oApp.IgnoreRemoteRequests = True oApp.Visible = False
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPublic oApp As Object Public workbookExcel As Object Public sheetExcel As Object Private Sub Macro() ' Fichier créé uniquement en vue de gérer les erreurs éventuelles Dim oAppError As Object Set oAppError = CreateObject("Excel.Application") 'Objects creation Set oApp = CreateObject("Excel.Application") oApp.IgnoreRemoteRequests = True oApp.Visible = False ' Set workbook worksheet Set workbookExcel = oApp.workbooks.Open(C:\Datas.xls") Set sheetExcel = workbookExcel.sheets("Sheet1") ' Launch the UserForm UserForm1.Show 'Close the workbook oApp.IgnoreRemoteRequests = False 'Il faut penser à le remettre sur false car ca peut creer des problemes d'apres ce que j'ai pu lire sur internet... workbookExcel.Close oApp.Quit Set sheetExcel = Nothing Set workbookExcel = Nothing Set oApp = Nothing Set oAppError = Nothing End Sub