kashif.special2005
Active Member
- Joined
- Oct 26, 2009
- Messages
- 443
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.
After opening the file I can use texttocolumn method, but if we have the method that we can open the file with delimited, and why it is not working.
Thanks
Kashif
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.
Code:
Sub opencsv()
Workbooks.OpenText Filename:=Range("B1"), DataType:=xlDelimited, Semicolon:=True
End Sub
After opening the file I can use texttocolumn method, but if we have the method that we can open the file with delimited, and why it is not working.
Thanks
Kashif