N
Niraj Kumar Singh
Hi ,
Let me introduce myself first .Myself is niraj working
as developer in Singpore. Pls help me out to resolve this
issue.
I export data from text file to excel Using
Workbook.OpenText method. Find below Syntax .
Workbooks.OpenText FileName:="C:\ips\ips.txt",
Origin:=xlWindows, _
StartRow:=1, DataType:=xlDelimited,
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False,
Semicolon:=False, Comma:=True _
, Space:=False, Other:=False, FieldInfo:=Array
(Array(1, 2))
..
Can i Pass string parameter to FieldInfo . FieldInfo is
one of the optional argument of OpenText method. I would
like to do this
Let me introduce myself first .Myself is niraj working
as developer in Singpore. Pls help me out to resolve this
issue.
I export data from text file to excel Using
Workbook.OpenText method. Find below Syntax .
Workbooks.OpenText FileName:="C:\ips\ips.txt",
Origin:=xlWindows, _
StartRow:=1, DataType:=xlDelimited,
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False,
Semicolon:=False, Comma:=True _
, Space:=False, Other:=False, FieldInfo:=Array
(Array(1, 2))
..
Can i Pass string parameter to FieldInfo . FieldInfo is
one of the optional argument of OpenText method. I would
like to do this