DWUTKA at marlow.com
DWUTKA at marlow.com
Fri Sep 22 12:49:32 CDT 2006
Why automate at all? Excel allows you to place external data on a spreadsheet, and you can have the sheet prompt to 'refresh' the data whenever excel is opened. It's pretty straight forward, and wouldn't require using any code. (Hey, wait, am I advocating a non-code approach? William may take away my 'Code Boy' title!) Drew -----Original Message----- From: Tina Norris Fields [mailto:tinanfields at torchlake.com] Sent: Friday, September 22, 2006 10:43 AM To: Access Developers discussion and problem solving Subject: [AccessD] Excel Graphs from Access Data - Ideas, Please Hi All, Client is an oil and gas producer. Daily data of several kinds are reported from the field on a daily basis. Client would like to be able to see graphs showing, for instance, daily production for well A for a selectable time range (the last month, this last week, this last quarter, whatever) - he would also like to be able to see daily production for two or three wells at a time on the same graph, or for all the wells in a given oilfield (individually or as a total). Once a query is devised for selecting the date range, the specific wells, or the complete oilfield (separately or in combination), I want to export the selected data to Excel and draw the appropriate graphs. And, I want to do all that fairly automatically. The client would like users to be able to tweak data in Excel for the graph, if need be - as in to exclude outlying data points - but, of course, not alter the actual data captured in the Access data table. So, I am thinking of using a make-table query and sending the data from the "made" table to Excel. Is this a good idea? Some of you have done some automation with Access and Excel, so I would appreciate knowing what the pitfalls are that I need to be careful of. I am thinking to build essentially template Excel files with already configured graphs for the choices that are going to be offered to the user - which well or wells, or which well-field, and for what date range? Does this sound like a good idea? With great care, I believe I can code I really would like your creative and technical advice, here - so, all ideas are welcome. Thanks, Tina -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com