The File Open command allows users to open url's instead of files only.
If i enter "http://myserver/mydb.nsf/myview?Openview&Start=1&Count=999" i
download the data without any problems in Excel 2000/97.
Using VBA script i've developed an Excel sheet that downloads all the data
(entries 1 to 10000 or more). You could then add code to automatically create
diagrams, do analysis etc. The Excel sheet can, of course, be downloaded once
and re-used until a new version is required.
The File Open command allows users to open url's instead of files only. If i enter "http://myserver/mydb.nsf/myview?Openview&Start=1&Count=999" i download the data without any problems in Excel 2000/97.
Using VBA script i've developed an Excel sheet that downloads all the data (entries 1 to 10000 or more). You could then add code to automatically create diagrams, do analysis etc. The Excel sheet can, of course, be downloaded once and re-used until a new version is required.