Runtime Error 5: QueryTable From Textfile Error

[mja37]

I'm using a macro developed on Excel 2002 but being run on Excel 2000. On the 2002 machine the macro runs find, however, on the 2000 machine I get a "Runtime Error 5: Invalid Argument or Procedure" when I try to access a querytable import from a user specified textfile.

 

[PHV]

On the 2000 machine feel free to play with the F2 key in VBE to discover which valid argument in XP isn't recognised in 2k.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244