Greg, For the interim, R:Scripter supports JScript, VBScript and PascalScript, all of which can instantiate Automation Objects. If you have existing VB5/6 code, it can easily be ported to VBScript and likely will work as it does now for you.
----- Original Message ----- From: "Greg Miller" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, February 09, 2005 11:39 AM Subject: [RBG7-L] - Re: Office Automation > Albert- > Is there any way to "map" certain pieces of data to certain cells using > Gateway? > > Thanks! > > > Greg Miller > > > > Albert Berry wrote: > > 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] > > >
