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
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
Go raibh maith agat
~M