Greg, have a look at a GATEWAY EXPORT and IMPORT option. GATEWAY supports XLS files. I visualize something along the lines of first exporting your header data, then the detail data into a combined sheet.
--- Greg Miller <[EMAIL PROTECTED]> wrote: > 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. > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
