troubleshooting Question

Reading .CSV format in Excel Object

Avatar of Amien90
Amien90 asked on
1 Comment1 Solution327 ViewsLast Modified:
exlApp.Workbooks.OpenText FileName:=TextBox1.Text, _
Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, _
Tab:=True, Semicolon:=True, Comma:=False, Space:=False, _
Other:=False, FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True

I need to rename the .CSV to .TXT to use this code. The problem is that the .CSV file containt ';' as seperator and not a ','. When i use Workbook.Open to open the .CSV, the data is not in the correct cells. Cell 1 contains 1;test;test2;test3;etc

I dont want to rename the .csv to .txt .. i want a code that will open the .csv file (cells seperator by ';') in an excel object. This all without rename the .csv to .txt

I use this code in outlook.

example .CSV File:
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros