You are viewing this page out of context. To see it in the context it is intended please click here.

About This Page

Reply posted by Jetze van der Wal on Fri 28 Dec 2001 in response to Keeping the boss happy

An alternative

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.