this is a weird one, the following bit of code is part of a longer sub, but this is the important part:
now i have been working on this spreadseet on my computer for quite some time, and its all working fine, yet when i run this on my collagues computer i get the following error:
Named arguement not found
this error then highlights the part:
what i dont understand is, how can it work fine on mine, but not work on his??
excel versions should be the same, as should be windoze....
any ideas?
Code:
' Open & import data and rename sheet
If f <> False Then
Workbooks.OpenText Filename:=f, 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)), TrailingMinusNumbers:=Truenow i have been working on this spreadseet on my computer for quite some time, and its all working fine, yet when i run this on my collagues computer i get the following error:
Named arguement not found
this error then highlights the part:
Code:
TrailingMinusNumbers:=Truewhat i dont understand is, how can it work fine on mine, but not work on his??
excel versions should be the same, as should be windoze....
any ideas?
