I have written a macro in Excel 2007 that includes importing a text file and
it works fine. But when a co-worker runs the macro in Excel 2000, she
appears to get an error in the "TextFilePlatform" command of the macro. I
have tried several values (437, 1252, 20127), but they all fail at the same
place. Incidentally, other macros that don't have the import function run
fine in Excel 2000.

Any ideas? Thanks.

You may find more instances of macros not being backward compatible. I
sometimes have to write a program in xl95 to accommodate end users.
Thankfully, it's not often.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Al @ Frontier" wrote in message
...
I have written a macro in Excel 2007 that includes importing a text file
and
it works fine. But when a co-worker runs the macro in Excel 2000, she
appears to get an error in the "TextFilePlatform" command of the macro. I
have tried several values (437, 1252, 20127), but they all fail at the
same
place. Incidentally, other macros that don't have the import function run
fine in Excel 2000.

Any ideas? Thanks.