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.
