Vlookup and Zero values

[zaska]

Hi,

Can anyone help me in trimming the below code.

Workbooks.OpenText Filename:="E:\Macros\Input\MTO_" & Format(Workbooks("NSE Converter.xls").Sheets("Sheet1").Range("G2").Value, "ddmmyyyy") & ".DAT", Origin:=437, _
StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=True _
, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), _
Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), TrailingMinusNumbers:=True

Thank you

 

[CharlesChuckieCharles]

whats wrong?

 

[zaska]

Hi,

I would like to know whether i could omit the false values. Looking to trim this code if possible

Thanks for the response

 

[CharlesChuckieCharles]

since its parsed into columns on opening i think this is the least you can get away with, but is it worth it?

Workbooks.OpenText Filename:="E:\Macros\Input\MTO_" & Format(Workbooks("NSE Converter.xls").Sheets("Sheet1").Range("G2").Value, "ddmmyyyy") & _".DAT",DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
Comma:=True , FieldInfo:=Array(Array(1, 1), Array(2, 1), _
Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1))

 

[zaska]

Thank you for the feedback

I don't know much about it just wanted to know whether it is possible to tweak by omitting the False parameters.