ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 macro compatability (https://www.excelbanter.com/excel-discussion-misc-queries/252091-excel-2007-macro-compatability.html)

Al @ Frontier

Excel 2007 macro compatability
 
I have created a macro in Excel 2007 that includes importing a text file. It
works fine on my PC, but fails on a co-workers PC running Excel 2000. The
failure points to the "TextFile Platform" command in the macro. I have tried
several (437, 1252, 20127), but get the same results.

Any solution?

Thanks you.

Ron de Bruin

Excel 2007 macro compatability
 
Have you try
xlWindows



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Al @ Frontier" <Al @ wrote in message
...
I have created a macro in Excel 2007 that includes importing a text file. It
works fine on my PC, but fails on a co-workers PC running Excel 2000. The
failure points to the "TextFile Platform" command in the macro. I have tried
several (437, 1252, 20127), but get the same results.

Any solution?

Thanks you.




All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com