Hi
A user has a new pc running windows xp office 2000 and since cannot run a
macro I wrote which opens a .txt file manualy the file can be openned on new
pc .
I even record macro it recorded all key strokes and opened file but when I
tried recorded macro it failed with message
file cannot be accessed file maybe read only or read only location or server
document is on is not responding retry or cancel the vb message is run time
error 1004
method 'open text' of object 'workbooks' failed
as can be done manually why not as macro if I save file as .xls then write
macro macro works but do not want to do this

the macro i recorded is as follows
Sub Macro1()

Workbooks.OpenText Filename:="L:\SYMDATA\Amy\060905.txt",
Origin:=xlWindows _
, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 2),
Array( _
7, 1), Array(39, 1), Array(47, 1), Array(53, 1), Array(59, 1),
Array(70, 4), Array(83, 4), _
Array(95, 4), Array(107, 1), Array(117, 1), Array(123, 1),
Array(131, 1), Array(143, 1), _
Array(152, 1))
End Sub
any ideas would be much appreciated
Thanks Tina