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.
