I have the following very simple statement (where the handle is correct)
MODIFY hExcelWks Range("I:I")::NumberFormat("0.00")
This is totally standard in many of my apps, and works in all of them, but I have received a .xls file from a user, where this simply has no effect. I have run through debug, and everything is happening as it should, except the MODIFY has no effect at all, the format of the column remains unchanged.
The cells are not protected, as the change can be made manually in Excel, any ideas on what might have been done when this file was created? there seems to be some form of protection but I cant figure out what. The user has no idea, as it is created automatically by a payroll package, not the users themselves