Information générale
Titre:
Excel OLE Automation and WrapText
Using VFP 6 I export a spreadsheet to Excel 97. OLE Automation is used to format (fonts, column widths, etc.) the spreadsheet. Everything is fine until I add a WrapText to the code. Then, the save of the spreadsheet using SaveAs and the Close (there is no code between the SaveAs and the Close) start acting up. The Close generates a message asking if I want to save my changes to the XLS. If I say I want to save my changes I get another message notifying me that my spreadsheet is in a prior version of Excel and asking if I want to convert to the current version.
If I remove the WrapText and leave all of the other calls to Excel to format the spreadsheet, I no longer get the 2 messages.
Any thoughts?
Tim
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement