Macro line calling a VBA Script in Excel does not work

[Talat]

Hi,

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:

=RUN('G:\PUBS\PP-MS\INVOICES\INVSALE.XLS'!Module1.InvoiceToBatch)

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:

=RUN('G:\PUBS\PP-MS\INVOICES\INVSALE.XLS'!Module1.InvoiceToBatch)

Can anyone point where this is falling down?

Many tahnks.

Talât

[Hack]

What is the error?

[Talat]

What is the error?

Macro error at cell
[Salemac.xlm]salemac!A289

Halt Step Continue


Cell Salemac!A289 has

=RUN('G:\PUBS\PP-MS\INVOICES\INVSALE.XLS'!Module1.InvoiceToBatch)