We have a useful (and complicated) add-in written in Excel 4 macro language,
that has been in use for many years, but which needs updating. We have
edited, updated and tested the macro and it now runs as required. All we
have to do now is save the updated version as an add-in, to replace the
previous version. But Excel won't let us.
Previously, using Excel 5, we used the VBA.MAKE.ADDIN command to do this,
but now we have Excel 2000, and this command just causes a "macro error".
We can't run the VBA.MAKE.ADDIN command at all, neither from a macro nor from
a visual basic module as suggested by Microsoft at
http://support.microsoft.com/kb/q114436. Please help.