How do you pass data to R:Scripter? Does R:Scripter have the ability to query the R:Base database directly? If there is a way to pass many fields of data to R:Scripter at once, then it seems like it will be perfect for the task!
Thanks!
Greg Miller Event Imaging Solutions, Inc.
MikeB wrote:
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]
