Greg: I have something similar to what you need that I used to generate graphs in Excel. What I did is create a spreadsheet template where the fist worksheet contains all the raw data and subsequent worksheets contain the graphs; then, I used an SQL statement from within Excel to read data from an R:Base table (cannot be a temporary table) through ODBC that contained the required data. The SQL query is stored with the spreadsheet and all you have to do is to refresh the spreadsheet using the Excel top menu DATA>Refresh Data; you can probably create a macro that starts when the spreadsheet is opened that would refresh the data automatically. The entire process is run from an R:Base form that creates the table, loads the data and launches the spreadsheet. Let me know if you need the code and/or spreadsheet to use as a guide. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Greg Miller Sent: Wednesday, February 09, 2005 10:26 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Office Automation R:Gurus- I am in the process of migrating some existing VB6 applications to R:Base 7.1. One of our applications that severely needs updating is an old VB program designed to create Excel speadsheets. We provide sales reports to each of our locations via spreadsheet. Each spreadsheet contains only that location's sales figures. We have a template spreadsheet that contains all of the formulas and formatting. When we run this program, it layers pieces of data into specific cells in the spreadsheet and then saves the spreadsheet with the location's name. Since we have over 200 locations, we try to automate the process as much as possible! Is there any way to accomplish this from within R:Base 7.1? Currently, I use VB's COM (ActiveX) structure to accomplish this task. If this is currently impossible directly (probably not for long!) from within R:Base, is it possible to write a program/script in VB/VBS that would plug in to R:Base (UDF?) to make this a possibility? Thanks! Greg Miller Event Imaging Solutions, Inc.
