Karen, You get real data.
>From within Excel you can create your other workbooks on the fly. You create the new workbook as an object, manipulate it to your hearts content based on your data, save it, and throw the object away. Repeat as needed to make all your workbooks. I think you will like it. There is much to learn, but the power is amazing. Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, March 10, 2010 10:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: OT (Sort of) : [RBASE-L] - Re: Reports to Excel You lit a fire, Mike! Even if I don't use this for this application, I think I will dust this off and play around with it! Thanks for the sample code, but it appears to NOT be ascii text, I get binary characters. Is that right? Karen In one of my Word apps, I connect to RBase for an envelope addressing program. I am going to email you the VBA code to connect to an RBase db, set a recordset, etc. You can glean from that enough to get you started. When you are in the VBA editor in Excel, find the Object Viewer. It will list all the properties and methods of the Spreadsheet which will give you clues about how to go about manipulating your data. This incident is another reason I have encouraged people to grasp at least VBScript as a useful tool as it is basically a subset of VB5/VB6 from which VBA is based. Almost all of the language constructs are interchangable. In our (I mean the developer community at large) there are few times that the data doesn't become entwined with Microsoft Office products at some point, so the above advice will likely hold true for some time. I know MS has experimented with using Dot Net as the basis for Office products, but to date it has failed miserably due to its' cumbersome size which translates to snail pace performance.
