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 > > >
