View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert[_34_] Robert[_34_] is offline
external usenet poster
 
Posts: 6
Default TextToColumns 2000 and 2003 differences?

Hello,

I have some code that runs perfectly using the TextToColumns function
in Excel 2003. However when I try to run it on another computer with
2000, I get the error

"Run-time error '1004':
Application-defined or object-defined error"

Here is the command it is stuck on...

Selection.TextToColumns Destination:=rUserAcct.Offset(iRowDown, 0),
DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(21, 1), Array(34, 1),
Array(50, 1), Array(59, 1), _
Array(67, 1), Array(68, 1)), TrailingMinusNumbers:=True

I double checked the selection and it looks correct before it is sent
to this function. Is there missing functionality in 2000 that
supports this command in 2003? If so, there another way to write this
so they will be compatible?