I have written following code attached alongwith in vb script, now I want to change the column or cell format to text of data in column 3 since I want to attach a leading 0 to the data "val" in the output xls in which I am writting data. In the code "val", "fn" & "ln" are some string data.
Please give me a solution to this.
Set xlwb = xls_app.Workbooks.Open(jcdest & "jc_template1.xls")
set xls_sheet = xlwb.sheets("Sheet1")