i have vfp9 application generates excel files using automation, starting :
**oexcel = createobject(“excel.application”) oworkbook = oexcel.workbooks.add()** . . .
excel 2013 being used. sheet populated, formatted , saved . works fine on windows 7 32-bit machine. on windows 7 64-bit machine, instructions fail. in particular :
**oworkbook.saveas(<newfilename>)**
fails message “unable saveas property of workbook class”
as work-around, have created before creating excel object, , called :
**oworkbook.save ()**
this works. have other users experienced this; there other limitations on use of excel vfp when running on 64-bit machine.
thanks
neither oworkbook.saveas() nor oworkbook.save() have problems on 64 bit machine (i assume meant windows (7/8/10) 64). problem should else.
Comments
Post a Comment