I have a CSV (delimited character is ;) file and want to convert into EXCEL file using a VB program directly . For this I written following code :
Dim ex1 As Excel.Application
Dim ex2 As Excel.Workbook
Set ex1 = CreateObject("excel.application")
Set ex2 = ex1.Workbooks.Open("c:\a.csv")
ex1.Visible = False
My problem is that , I got the file in EXCEL , but delimeter characters are appearing in EXCEL file and no column wise seperation as per Delimeter character is made .
Kindly guide me with a sample code how to achieve the same .