Hi Steve, thanks for that
My client is unhappy where I told him to do a Save As.....
His reaction, "it was ok before, what have you done to it"
I've also just noticed that suddenly, my routine to SaveAs from within
my App, it is now saving the file as an XLSM file. I'm sure it wasn't
doing that before.
i.e
my code is
newfile=SYS(5)+CURDIR()+"xfile"
oWorkbook.SaveAs('&newfile',39)
oExcel.quit()
I wonder if its something to do with my upgrade to VFP-SP2 ?
S
On Tue, Jul 27, 2010 at 1:39 PM, Steve Ellenoff <[email protected]> wrote:
> 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.
