Macro error opening text file

J

Jim C

I built the following macro on Excel 2003 SP2, It ran on 2 other network
computers running Excel 2000 until just recently, one computer was replaced
and the other had no changes. I can run it from the working computer from
the same netrwork folder as the non-working computers. It used to work on
the non-working computers so I am confused.

I get a Visual Basic error "Compile error: Named argument not found". The
last argument in the macro code "TrailingMinusNumbers:=" is highlighted, the
following "true" is not highlighted.

Here is the full macro:

Sub FK_open_Q5()
'
' FK_open_Q5 Macro
' Macro recorded 9/22/2008 by
'
' Keyboard Shortcut: Ctrl+Shift+Q
'
ChDir "H:\Public\DDMS Reports"
Workbooks.OpenText Filename:="H:\Public\DDMS Reports\Q5-QUOTE.TXT",
Origin _
:=437, StartRow:=1, DataType:=xlDelimited,
TextQualifier:=xlDoubleQuote _
, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:= _
False, Space:=False, Other:=True, OtherChar:="|", FieldInfo:=Array( _
Array(1, 1), Array(2, 2), Array(3, 1), Array(4, 1), Array(5, 1),
Array(6, 1), Array(7, 1), _
Array(8, 2), Array(9, 1), Array(10, 1), Array(11, 2), Array(12, 1),
Array(13, 1), Array(14, _
1), Array(15, 1), Array(16, 1), Array(17, 1), Array(18, 2),
Array(19, 2), Array(20, 1), _
Array(21, 2), Array(22, 1), Array(23, 2), Array(24, 1), Array(25,
1), Array(26, 1), Array( _
27, 1), Array(28, 1)), TrailingMinusNumbers:=True
End Sub

Thanks for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top