Hi there,
without any problems I execute a macro in a Word file from Access with this command:
Now I would like to pass a parameter with this command:
In Word I retrieve the variable with:
Even though I only check if the variable has been transmitted with MsgBox (strDirectoryPath) in the Word file, all of a sudden I get an automation error in Access. Can anybody help me with this? These are the only changes I did, and the message box shows the variable content, so passing the parameter works. But what does cause the error? Thanks for help.
Frank
without any problems I execute a macro in a Word file from Access with this command:
Code:
Application.Run MacroName:="fill_with_data"
Code:
Application.Run MacroName:="fill_with_data", varg1:=strDirectoryPath
Code:
Public Sub fill_with_data(Optional strDirectoryPath As String)
Frank