I have a macro file in the old format (pre2003) that does a lot of complicated automated things. Since then (with help) I have developed some VBA scripts to enhance it.

Recently a need arised to make a call from the MACRO file to run a VBA script, and the system is complaining. The VBA script is fine. If you run it as a stand alone works perfectly.

Here is the MACRO line calling it:


Macro file is in a separate file, opened and hidden : It is linked to the INVSALE.XLS sheet and the VBA script is in Module 1 in the INVSALE.XLS.

Basically, the process stops with an error on Macro line XX which has the following code:


Can anyone point where this is falling down?

Many tahnks.