Hi,
I have a csv file with approx 800000 data with semicolumn delimineted, and I am using below method to open this file with delimineted, It opens the csv file but not in seperate column.
Sub opencsv()
Workbooks.OpenText Filename:=Range("B1"), DataType:=xlDelimited, Semicolon:=True...