ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using an Excel 2003 Macro on Excel 2000 (https://www.excelbanter.com/excel-programming/346454-using-excel-2003-macro-excel-2000-a.html)

Spike[_3_]

Using an Excel 2003 Macro on Excel 2000
 
I have a Macro designed in Excel 2003. I need it to work on Excel 2000. It
calls commands from the 2003 library. Can i transfer this library anyhow? or
must i install 2003 on the computer running the macro

--
Jeff "Spike" Zapinski
Faurecia Automotive Seating - Project Engineer

Leith Ross[_325_]

Using an Excel 2003 Macro on Excel 2000
 

Hello Spike,

If you post your macro code, the differences could be spotted and
corrected. This is an easier solution that trying to re-install
libraries and other components.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=487722


Spike[_3_]

Using an Excel 2003 Macro on Excel 2000
 
Thanks Leith,

Since i did not realize that the computer the program was going to run on
was not excel 2003, i used such things like the FileDialog property, and
since the FileDialog property was not available in excel 2000, the program
wont be as user friendly as i would like it. I can make a scaled back
version, but i would rather not.

--
Jeff "Spike" Zapinski
Lear Corporation - Technical Specialist


"Leith Ross" wrote:


Hello Spike,

If you post your macro code, the differences could be spotted and
corrected. This is an easier solution that trying to re-install
libraries and other components.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=487722




All times are GMT +1. The time now is 01:24 PM.

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