Saving Excel files in different versions

[RoadRunnerOz]

Any ideas on how to save an excel file V5 as Excel V7 through automation?

I tried ....activeworkbook.saveas(filetosave,Xlformat7)
where Xlformat7=43

Excel still asks me if I want to save in the new format.

Thanks Michael Ouellette
mouellette@compuserve.com

 

[danceman]

I am dealing with office 97, so there may be differneces in discriptors. have you tried setting the excel global XlFileFormat property to xlExcel7? Attitude is Everything

 

[RoadRunnerOz]

I have no control over 100's of PC's set up at users site. Some have Office 97, some have 2000 and some have XP.
VFP 6 exports in Excel 5 format.
using this creates the prompt:
oleapp.APPLICATION.activeworkbook.saveas(myfile)

There must be a way programatically to save in a different
excel version by passing a parameter. Looking a VB code it seems like ...activeworkbook.saveas(myfile,-43) should do it but noooo.

Thanks in advance Michael Ouellette
mouellette@compuserve.com

 

[monikai]

HI !!
Why is important the version of Excel?
If you don't write xlformat - it'll be written in Excel in theirs computer. Have you any special function in sheets?
Monika Kind regards to you all from Warsaw !!!!!

 

[danceman]

#define xlExcel7 39
oleapp.APPLICATION.XlFileFormat = xlExcel7

XlFileFormat is a excel global property. Attitude is Everything

 

[RoadRunnerOz]

monikai: I don't care about the version. I don't want the user to have to answer any questions. Saying yes to 100 files is a bit tedious.

My solution was:
oexcel.Application.displayalerts=.f. <--
oexcel.activeworkbook.saveas(m.efile,43)

Looks like oleapp.APPLICATION.XlFileFormat = xlExcel7
would also work.

Thanks all Michael Ouellette
mouellette@compuserve.com