Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
christian77
Partner - Specialist
Partner - Specialist

EXECUTING A MACRO IN IE

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?

Thanks.



8 Replies
Not applicable

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)

Miguel_Angel_Baeyens

Hello Christian,

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.

Regards.

christian77
Partner - Specialist
Partner - Specialist
Author

Hi:

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.

Thaks again.

Miguel_Angel_Baeyens

Hello,

You can use the url you have to launch to pass a parameter to a variable, then perform a selection using that variable:

http://server/folder/document.qvw?variable=value&variable2=value2


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.

Regards.

christian77
Partner - Specialist
Partner - Specialist
Author

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.

Miguel_Angel_Baeyens

Hi,

Try the following in AJAX client

http://**.**.***.*/QvPlugin/opendoc.htm?document=EspacyoAnalisis.qvw&select=OID,AIG4980


Where OID is the object ID that contains the field ARTICLE. This should work.

christian77
Partner - Specialist
Partner - Specialist
Author

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.

christian77
Partner - Specialist
Partner - Specialist
Author

It does not. QV 9 SR4...