Can you imagine the money spent for all those Office 2007 licenses, and they tell you not to upgrade. The shame, you have a tough client.
You might consider VBA/C++ and several examples of code (I found a couple source codes for 2007Excel that read the BIFF12 format embedded in Excel) that are out there, to get you where you want to be. It would cost more than them just biting the bullet to upgrade to 9.0, but just think of the fun you have in the mean time. NOT! Good Luck, Paul D. From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, October 29, 2009 4:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Office 2007 and old RBase Believe me -- this is one more thing to put in my arsenal! They have 6 licenses of 7.6 at the company, but none for this department. In this department, we're using RBase 6.5++ as a front end to prepare reports from other data sources, and they will not let us connect directly to those data sources so ODBC or any other kind of connection is not allowed. That's why we just get files from these other sources, either .csv or Excel workbooks. Karen I am happy you have found a reasonable workaround! But when you think of it an upgrade to 7.6 or extreme is a better option for you and the client’s future. If you want to stay current, you should stay current for R:Base and Excel alike!! I do understand your client is a large company that requires full control of software without any intervention from outside, but to stay old on one piece and new on an other is bad management sooner or later from their perspective they will be hit. Sorry to be messenger for bad news in the long run! But still the workaround will work for x years to come My only suggestions are to upgrade and maybe utilize ODBC instead of gateway which I find more elegant when integrating foreign data sources including Excel.
