If want to start a Word macro from Access. For this I use the code which stands under. Is it possible to give a variable that can be used in the macro?
' Word starten
Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
WordApp.Visible = True
' macro starten
WordApp.Application.Run "StandVanZaken"
Set WordApp = Nothing
The Function in Word start with StandVanZaken(string), en the string I want to give in access.
I hope you understand what I mean, because my English is not so good
' Word starten
Dim WordApp As Object
Set WordApp = CreateObject("Word.Application")
WordApp.Visible = True
' macro starten
WordApp.Application.Run "StandVanZaken"
Set WordApp = Nothing
The Function in Word start with StandVanZaken(string), en the string I want to give in access.
I hope you understand what I mean, because my English is not so good
