I'm trying to execute a macro when the document is being opened in Internet Explorer. It doesn't seem to work at all. Could somebody tell me how to do it?
Ensure the user has the latest IEPlugin installed and also that the security level allows the macro to run if it needs system access (press ctrl+shift+m whilst in the document in IEplugin to bring up the macro security options)
OnOpen and On PostReload macros will not execute when opening on server regardless the client you are using. Tell us something else about what you want to do so we can find a workaround for your issue.
What I want to do exactly is the next:
The QV doc. Is embedded in a aspx site. That page shows a list of articles. Once the user has selected an article, he can go to the QV doc and open it. The doc. must show only information about that article.
I need two things:
1º -- Pass the parameter of that article from the Internet page to QV
2º -- Read that Article_id and execute a macro, or a trigger that filters that field with that value.
Does anybody know how to do that.
You can use the url you have to launch to pass a parameter to a variable, then perform a selection using that variable:
Haven't tested though, but since on open macros are not allowed, and you are passing parameters as values, check the use of "On Change" or "On Select" for variables.
Hi: This is what i´m doing. The doc opens.
<iframe id="contenedor2v" name="contenedor2v" src=http://**.**.***.*/QvPlugin/opendoc.htm?document=EspacyoAnalisis.qvw&ARTICLE=AIG4980
frameborder="0" width="1024" height="768" runat="server" align="middle" visible ="true">
Now, how do I read that variable (ARTICLE) inside QV, in order to filter.
Try the following in AJAX client
Where OID is the object ID that contains the field ARTICLE. This should work.
Nope. It does not.
I´ve just installed QV 9 SR4, wrote the same line and it doesn´t do anything.
The objective is filtering only an article, but a different one everytime, based on the origin page.