VFP 7.0 and WIN2000 - Exporting file to Excel in Office XP 1

[ARS1]

We are in the process of having our OS converted from Win98 to Win200 and MS Office 97 converted to Office XP. I was using 'Export to (FileName) type XL5' which worked in Win95 and Win98 but is now failing in Win2000 with Office XP. Any suggestions?

 

[AirCon]

Try with XLS type

Export to (FileName) type XLS

-- AirCon --

 

[ARS1]

I changed the type from XL5 to XLS and it still bombed out. Any ideas?

 

[AirCon]

I think XLS is the latest excel version that VFP can export to. If that still gives you an error, I guess you need more work to do, like use Automation.

How about COPY TO ... TYPE XLS / XL5 ?

-- AirCon --

 

[AirCon]

ARS1,

I just saw a thread discussing about some incompatibilities about OfficeXP & W2K. Maybe it is one of the reason.

Look here: thread616-586196

-- AirCon --

 

[ARS1]

After making changes to the legacy code from type XL5 to XLS I found that there was an additional error. The problem ended up being that the XLS file path was set to c:\windows\desktop which is not valid in Win2000. I corrected the path to see the root drive and the problem was solved.

Thanks for your input. I was greatly appreciated!

 

[AirCon]

You're welcome

Regards

-- AirCon --