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]
