>hi all,
>I have an application that creates an excel file and have 2 problems.
>I need to format the cels to save them work so that they can enter something like 01/98 without excel trying to be clever and turning that into a date. I have tried the following
>
>OleApp.cells(lnCounter,4).NumberFormat = "@"
>
>but that does not work
For your first problem you have to set Fomat property to be "Text" before (not after) entering a value.
However, using Excel 2007 I could not figure out at the moment how to record a macro (don't see option/button), so can not translate it exactly into the code.
>My second problem is when reading the file back in I have a column that has a formula in it sum(G1*H1) but when I read it in I get errors. Normally when i read in from excel there is not a formula in the cell and this is the first time doing this, any pointer please.
>~M
If it's not broken, fix it until it is.
My Blog