Jim: Not sure I'm following what you're doing... Are you talking about setting up an Excel template and then bringing in the RBase data? I had thought of that but it isn't easy either. There are break points involved, with break headers, break totals.... When I do the .csv file I have a cursor thru each break section to print the header, unload the data, print the totals...
That's why I would love to design a nice looking report and have it to go Excel directly. Right now they have a blank Excel file with a macro that their IT guy created. They insert the .csv file into the blank file, and run the macro to format the fonts, has some complicated code that "finds" the break headers and will bold and underline them... I'll have to look at the macro code one day to learn how he did all this. Then the user has to resave it with the name of the factory and the monthend date. So the user must do this 100 times.... Karen > If this is going to be an EXCEL workbook, what about the first sheet > being formatted exactly how they want the report to look, then having the > information from RBASE going to the other sheet(s)? > > Another possibility is to have the Excel workbook connected to a specific > table in RBASE that can be updated whenever they want with an EEP. After > updating the RBASE info, they simply open the Excel workbook, click the > update button and the information is updated. The first sheet stays > formatted > and only the cells in the other sheet(s) are changed. I use this concept > for an excel workbook used here. > > > > Jim > > >
