How to unmerge the excel fields while exporting from crystal reports 9.2

I am exporting crystal report to excel file using vb6.0.

When i tried to export the crystal report file to excel the columns are merged.I need to unmerge all the fields so that i can manipulate da开发者_开发知识库ta in excel sheet.

---

for each ws in workbook
ws.activate
ws.rows.entirerow.select
selection.unmerge
ws.cells(2,1).select
next