OVH Cloud OVH Cloud

Comment executer une macro à chaque document ouvert

1 réponse
Avatar
Patrick
Comment faire pour que cette macro s'execute à chaque document !

Private Sub Document_BeforeClose(Cancel As Boolean)
Dim lenom As String, ledossier As String
lenom = ActiveDocument.Name
ledossier = "c:\Fipub\"
lenom = ledossier & lenom
ActiveDocument.SaveAs Filename:=lenom
End Sub
Merci.

1 réponse

Avatar
ClémentMarcotte
Copier la macro dans chaque nouveau document.

Ou

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_comaddinvb6.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/deovrBuildingCOMAddinsForOfficeApplications.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office06062002.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office03072002.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office03072002.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modcore/html/dewlkwalkthroughcreatingcomadd-in.asp

"Patrick" a écrit dans le message de
news:
Comment faire pour que cette macro s'execute à chaque document !

Private Sub Document_BeforeClose(Cancel As Boolean)
Dim lenom As String, ledossier As String
lenom = ActiveDocument.Name
ledossier = "c:Fipub"
lenom = ledossier & lenom
ActiveDocument.SaveAs Filename:=lenom
End Sub
Merci.