:confused: Hi i Have tried dMuch to set the Value In THe excel sheet from VIasual Basic But Cant Set .the Value Are Stored in Excel as a number i.e. Cell Format is in Number. I Want to Change The Format of Cell To Text
Set The Following Value in the Excel Sheet.
oSheet.Range("B2").Value = "0002e001"
plz try it. the VAlue Stored in Excel Sheet is :2.00 e 001