As Stan pointed out the databases uses a form to kick of the EXCEL export,
below is web agent that achieves the same effect, and can be called from Domino
R5 :
Sub Initialize
Print {Content-Type: text/x-ms-iqy}
Print {WEB}
Print {1}
Print {http://your open view URL}
Print "Selection=AllTables"
Print "Formatting=All"
Print "PreFormattedTextToColumns=True"
Print "ConsecutiveDelimitersAsOne=True"
Print "SingleBlockTextImport=False"
Print "DisableDateRecognition=False"
End Sub
The agent MUST been named XXX.iqy, eg. must have the extension .iqy.
As Stan pointed out the databases uses a form to kick of the EXCEL export, below is web agent that achieves the same effect, and can be called from Domino R5 :
Sub Initialize Print {Content-Type: text/x-ms-iqy} Print {WEB} Print {1} Print {http://your open view URL} Print "Selection=AllTables" Print "Formatting=All" Print "PreFormattedTextToColumns=True" Print "ConsecutiveDelimitersAsOne=True" Print "SingleBlockTextImport=False" Print "DisableDateRecognition=False" End Sub
The agent MUST been named XXX.iqy, eg. must have the extension .iqy.