Hi Brian, > I'd like to be able to specify the date range once and have the start > and end dates propagate to all queries without having to cycle through > each sheet, do a refresh, and re-enter the dates. Doesn't matter to me > if the parameter is obtained via a single dialog or reading off of a > calc cell. It would be nice if I could specify a default date based on > the current date.
Hmm, I don't think there's a way to do this without a little programming. In general, you would need to programmatically refresh the ranges. Two issues here - This is Calc API, I don't know how to do this. - I don't know whether this API supports passing parameters. That is, the API could be "refreshRange" (or so), and internally decide that it needs to ask for parameters; or it could be "refreshRange( ... )" where you can pass in some information. Even in the latter case ... I think there could be more hurdles, as you would need to implement an own class supporting a certain interface, which is not possible in Basic. Hmm. Try another way (still some programming, sorry): Instead of using parameters, let your queries base on fields in a certain table (which is for this purpose only). Now when it comes you want to refresh all ranges, run a Basic script which - asks for the date values - writes those values into the proper table fields - refreshes all ranges If this is where you think you can/want to go, the third still requires you ask some Calc-API-knowledgable people (I suggest [email protected]). For the first two, this list here could certainly help. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
