Why not call an agent that can be run anonymously. Set the agent to run with the rights of someone trusted, rather than the person invoking the agent. Your agent could then do print statements like
etc, etc. If you simply want to iterate over the docs in a view, it's a fairly simple loop for the TD tags. Also, I think there's a 1000 line limit on iqy files which you avoid with the agent.
If you store the url to the agent in excel, like an iqy file, the spreadsheet will update itself whenever you open it.
Why not call an agent that can be run anonymously. Set the agent to run with the rights of someone trusted, rather than the person invoking the agent. Your agent could then do print statements like
print |<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">|
print |<table>|
etc, etc. If you simply want to iterate over the docs in a view, it's a fairly simple loop for the TD tags. Also, I think there's a 1000 line limit on iqy files which you avoid with the agent.
If you store the url to the agent in excel, like an iqy file, the spreadsheet will update itself whenever you open it.