Well Karen I dont see your issue in detail. I need only 2 sheets in my case (Balance sheet an result sheet) I keep them the samw workbook with different sheets, they are both updated at the same tin when press updateall in Excel.
For hundreds sheet I would guess you need to divide into more then one workbook. Anyway if you really needs an sample on this approach, just e-mail me privately and I will send an sample I can only say it has benefits and drawbacks, like in most situations 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 9 mars 2010 17:48 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Re: Reports to Excel Yes, but I don't think your and Jim's way of doing it won't work in my application. I need to create about 100 spreadsheets. In each spreadsheet, there will be break headers, break footers with totals... I just don't understand how you could use a SQL-script and a live connection to the database to get these into the spreadsheet.... Karen Karen the way I address this problem is like this: First I create a perment temporay table with an SQL-scrpit according to my reporting needs.(with that I mean only its is a temporary table in logic but need to be permanent so it can be accessed by ODBC. Then I in Excel create an ODBC query to read my R:Base data base, once I have that I format the excel accordning to my needs and save . When I need that sheet with latest data I just press a button in excel that performs the query one time more. (There are a few minor things in the behaviour of excel) Having said this I also believe that Excel-reporting has become better since I developed my personal workaround. Gunnar Ekblad
