I ran into similar problems awhile back and the solution in my case was to get the users to save the data file in an earlier format "from within" Excel itself. In the "Save As" dialog, there's a Save As Type drop down, which if you scroll all the way down, shows older versions of Excel to save to. There may be warnings about compatibility etc, but have them ignore the warnings and proceed.
Since it can be done manually from within Excel, you should be able to automate the process in VFP using Automation if you need. The easiest way is to record a macro and do the process manually yourself, then open up the VB script code and translate it into VFP automation code ( usually not that hard to do ). You'll need to make sure Office 2007 is installed on the machine where your VFP app is installed so the automation can work. HTH- Steve At 08:23 PM 07/26/2010, you wrote: >Hi Folk > >I don't know if this is my 1st real encounter with Foxpro "end of the >road" syndrome... > >I have a large customer who prepares data in Excel, which my system >then imports. >This worked fine till they had some users who used Office 2007 > >I found a way to Try/Endtry this problem and auto SAVE AS to an >earlier version (Excel format 39) >This has now suddenly stopped working. >I suspect they've applied some sort of Compatibility conversion to >their template, but I'm still trying to determine this > >Does anyone know of a utility which will auto convert and XLS/XLSX >file to a Excel 97 or 2003 format? >(Command line conversion is ok too) > >The spreadsheet has 4 sheets. I'm only concerned with Sheet 3 >I import all the way to column CX, Row 300 > >How can I tell what version the actual spreadsheet is? >(i.e. in 2007 there seems to be no "properties" button? > >-- >Regards >Sytze de Boer >Kiss Systems >Hamilton, NZ >Ph: 64-7-8391670, Mob:64 21 937611 >URL: www.kiss.co.nz > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
