Karen Repeating again I still think ODBC from Excel is you best option.
What can I say to convince you? At least explore it! Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För [email protected] Skickat: den 10 mars 2010 15:45 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Re: Reports to Excel Repeating again -- I need a separate spreadsheet for each factory. 100 different spreadsheets, 100 different names... These are emailed separately to each factory with just their data. I do NOT want multiple sheets in one workbook I can probably put all the data in an RBase table, including the column header text, the footer text and totals, with one field that indicates the factory, assuming that the Excel functions keep the data in the same order. Then the macro would have to do the following (1) grab all the data for the first factory and pull into a sheet, (2) run thru and format the data so there's special fonts/sizes for headers and footers, (3) save that sheet to a separate file, somehow including the factory name and the date (maybe another field in my table?), and then (4) go onto the next factory. You're saying that a macro could do all that? If so, then it's better than them bringing the 100 .csvs up one at a time and running a macro. However, it seems to me like being able to print a specially-designed RBase report directly to a spreadsheet would be a total no-brainer. Karen I have a single EXCEL workbook that has 52 worksheets (one for each week). This workbook has multiple links to other workbooks. It can be updated with a click of the update button. I also have ones with links directly to RBASE tables that update in a similar manner. If the IT guy on the other end knows how to have macros or links, I would think a single workbook could be created with a sheet for each report pre-formated for each factory. The truth is you could do it (I did it by just reading the HELP info so I am sure you could do it). Once that is accomplished, the specific information for your detail, headers, footers could be put in the RBASE tables with a field for each factory. The Excel workbook then has as many sheets as needed that attach to the tables. Hitting the update button on the Excel sheets will automatically update all 100 report sheets based on the factory id. Of course this is all predicated on the Excel sheet having access to the RBASE tables. I now do this with a quote file our people use when creating products on the fly so to speak. Excel workbooks are only limited in size based on the available memory. Just a thought. Jim
