Re: Macro crashing on different computer

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 07/07/04 

Date: Tue, 6 Jul 2004 22:10:47 -0700

So, it looks identical up through field info. But I seem
to be having a problem, even if I end it right at

Array(48, 1))

Shouldn't it work that way with EXCEL 2000?

Thx,
G

>-----Original Message-----
>yep... version incompatibility.. :)
>
>next time just check MSDN:
>
>
>excel 2000
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
>us/off2000/html/xlmthOpenText.asp
>
>OpenText Method
>
>Loads and parses a text file as a new workbook with a
single sheet that
>contains the parsed text-file data.
>
>Syntax
>
>expression.OpenText(Filename, Origin, StartRow,
DataType, TextQualifier,
>ConsecutiveDelimiter, Tab, Semicolon, Comma, Space,
Other, OtherChar,
>FieldInfo, DecimalSeparator, ThousandsSeparator)
>
>
>
>excel 2002
>
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
>us/vbaxl10/html/xlmthOpenText.asp?frame=true
>
>OpenText Method
>
>Loads and parses a text file as a new workbook with a
single sheet that
>contains the parsed text-file data.
>
>expression.OpenText(FileName, Origin, StartRow,
DataType, TextQualifier,
>ConsecutiveDelimiter, Tab, Semicolon, Comma, Space,
Other, OtherChar,
>FieldInfo, TextVisualLayout, DecimalSeparator,
ThousandsSeparator,
>TrailingMinusNumbers, Local)
>
>
>
>
>
>keepITcool
>
>< email : keepitcool chello nl (with @ and .) >
>< homepage: http://members.chello.nl/keepitcool >
>
>
>"Grace" <anonymous@discussions.microsoft.com> wrote:
>
>> I am virtually certain, before I left home, this macro
>> worked fine on my home computer. I am trying it on a
>> visited computer, as a test for doing it before a
client
>> soon on their computer, and it is crashing:
>>
>> Workbooks.OpenText Filename:=myFilename, Origin:=437,
>> StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(
_
>> Array(0, 1), Array(7, 3), Array(17, 1), Array
(32,
>> 1), Array(40, 1), Array(48, 1)), _
>> TrailingMinusNumbers:=True
>>
>> It is giving me a comile error: Named argument not
found
>> and when i hit debug, it highlights the part that says
>> TrailingMinusNumbers:=True, as if that is the
offending
>> part.
>>
>> I note that, it I record that part of the macxro on
this
>> visiting computer, it does not record that seemingly
>> offensive ending. Also, instead of Origin = 437, it
says
>> origin:=x1Windows, though when I try editing my macro
>> with either of those, it crashes on those. I also
note
>> that this computer has EXCEL 2000, not 2002. Can
someone
>> help, please?
>>
>> Thanks
>> G
>>
>
>.
>

Relevant Pages

  • Re: Macro crashing on different computer
    ... >>ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, ... >Other, OtherChar, ... >>FieldInfo, DecimalSeparator, ThousandsSeparator) ...
    (microsoft.public.excel.programming)
  • Re: American semicolons
    ... claim that Americans 'only use ";" to separate two things that would ... semicolon can be a strong comma as well as weak period. ...
    (alt.usage.english)
  • Re: Cannot multiselect programmatically?
    ... I am just using the semicolon to separate the items in the list (and to end ... > comma-delimitd list but the comma is not part of the list value. ... >> items in the listbox already selected by default when the form is loaded. ... How do I programmatically select multiple items in the list? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Find and Replace with Wildcards
    ... This starts with a semicolon, finds everything but a semicolon and comma up ... A peer in "peer to peer" support ... > I turned wildcards on and did a find and replace using the following> values for starters: ...
    (microsoft.public.word.docmanagement)
  • Re: comma operator
    ... may have returned has been discarded by the comma; ... and the semicolon at the end discards the value ... extra gyrations to make the second function ...
    (comp.lang.c)