I'm automating Excel from vb. I've a sheet object and I'm assigning
l_oSheet.Cells(Row,Col).FormulaR1C1 = CStr("03")
If I step it when I look at the contents of
l_oSheet.Cells(Row,Col).FormulaR1C1, It shows it is 3. I don't actually want
that but what I've assigned i.e. "03".
Do I have to set some other column property or assign to a different cell
property?
Thanks
Simon
Bookmarks