psittacus
06-14-2005, 09:48 AM
Hi, I'm trying to write a subroutine that automatically opens a tab deliniated text file and I keep getting a "expected variable or function" error for the following line:
With Application
.Workbooks.OpenText(Filename:=InputName, Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, Fieldinfo:=
Array(1, 1, 1, 1, 1, 1, 1, 1))
End With
This isn't the whole code, just the bit that's giving me grief. Any help would be appriciated.
Thanks
With Application
.Workbooks.OpenText(Filename:=InputName, Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, Fieldinfo:=
Array(1, 1, 1, 1, 1, 1, 1, 1))
End With
This isn't the whole code, just the bit that's giving me grief. Any help would be appriciated.
Thanks