64bit - Calling Excel from VFP9 on 64-bit machine -


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