Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro error opening text file
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 -- Jim C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error opening edited XML file - Where is the error log? | Excel Discussion (Misc queries) | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
error opening excel file | New Users to Excel | |||
error opening excel file | Excel Discussion (Misc queries) | |||
macro error when opening any file | Excel Discussion (Misc queries) |