Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm currently working on Qlikview 9, and in a qlikview macro, I manage word application. At a certain moment, I execute a macro written in the word document. It works fine, by using this :
Set objWord = CreateObject("Word.Application")
objWord.Visible = True
Set objDoc = objWord.Documents.Open("myWorddoc.doc"')
objWord.Application.run "myexternamacro"
BUT now I try to pass a parameter to the word macro like this :
objWord.Application.run "myexternamacro","myparam1"
It works the macro is executed, the parameter is taken over in the word macro, but the Qlikview macro stops at the current line (without any error message), and the code which follows is not executed
Have you an idea ?
Solved.
Just by adding the command 'On error resume next' before, like this:
onerror resume Next
objWord.Application.run "myexternamacro","myparam1"