General information
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only