Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub Workbook_Open() CreeMonBouton End Sub
Private Sub CommandButton1_Click() Exportermodule End Sub
Option Explicit Dim chemin As String Sub RecopieModule() Dim NewM As Object, NewCode As String ' Stockage du code du module "Module1" du classeur maitre With ThisWorkbook.VBProject.VBComponents("Module1").CodeModule NewCode = .Lines(1, .CountOfLines) End With ' Ajout d'un module au CLASSEUR ACTIF Set NewM = ActiveWorkbook.VBProject.VBComponents.Add(1) With ActiveWorkbook.VBProject.VBComponents(NewM.Name).CodeModule ' Le DeleteLines sert à éviter éviter d'avoir 2 fois Option Explicit ' si la déclaration explicite est cochée dans les préférences 'sans effet si l'option n'est pas cochée .DeleteLines 1, .CountOfLines .AddFromString NewCode End With End Sub Sub Exportermodule() NbFich Workbooks.Open Filename:=chemin RecopieModule End Sub Sub NbFich() Dim Workb As Workbook For Each Workb In Workbooks chemin = Workb.FullName Next Workb End Sub Sub CreeMonBouton() Dim bar Set bar = Application.CommandBars("Standard") With bar.Controls.Add(msoControlButton, , , , True) .Caption = "Module" .FaceId = 351 .Tag = 1 '.Style = msoButtonCaption .OnAction = "L_Start" End With End Sub Sub L_Start() UserForm1.Show End Sub
Sub L_Start() Exportermodule End Sub
Sub NbFich() Dim Workb As Workbook For Each Workb In Workbooks chemin = Workb.FullName Next Workb End Sub