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 .
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.