New Response

« Return to the main article

You are replying to:

    • avatar
    • Jetze van der Wal
    • Posted on Fri 28 Dec 2001

    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.

Your Comments