Export to excel using Tools run Macro.

[Balaji Vaddepalli]

Hi all,

I have tried to call an agent that exports to Excel using "Tools Run Macro", but I have not succeed in that as the Ext.nd doesn't support the "ToolsRunMacro". Could you please anybody suggest on how can we run the existing Lotus script agent which exports the view data.

Thanks in advance.

Regards
Balaji.

[Zakaroonikov]

Hi all,

I have tried to call an agent that exports to Excel using "Tools Run Macro", but I have not succeed in that as the Ext.nd doesn't support the "ToolsRunMacro". Could you please anybody suggest on how can we run the existing Lotus script agent which exports the view data.

Thanks in advance.

Regards
Balaji.

Could you not call the agent via

http://server/databasepath/agentname?OpenAgent

Of course this will only work if the agent has been designed for the web.

[Balaji Vaddepalli]

Yes I am doing the same, thank you..

I have an questio on Documentcontext is not working once we calling the agent using OpenAgent.
Can you let me know how can we get the handle of the current docuemnt once we call the agent.

Regards
Balaji.

[Zakaroonikov]

Yes I am doing the same, thank you..

I have an questio on Documentcontext is not working once we calling the agent using OpenAgent.
Can you let me know how can we get the handle of the current docuemnt once we call the agent.

Regards
Balaji.

You could try passing the UNID as a parameter in the query string ie ?OpenAgent&UNID=23423423423423

And then using the agent to extract the unid from the query string.

[Balaji Vaddepalli]

thank you for your help...

Its works :-)

Regards
Balaji.