Run method for subroutines

[Scott]

Hello,

I have a master workbook(1) that opens a second
workbook(2) and I would like to call a subroutine in
workbook(2) from workbook(1). The subroutine will perform
calculations in workbook(2).

I have found a way to do this by manually setting a
reference to workbook(2) in workbook(1), but I'd like to
do it without adding a reference.

When I use the line:

Application.Run("CC.xla!Calculateconfig",var1,var2)

I get an error saying it expects an “=”.

The subroutine I’m trying to call is in a workbook
called “CC.xla”, the “ThisWorkbook” module, and is
named “Calculateconfig”.

Any suggestions?

 

[Tom Ogilvy]

Take the routine out of the ThisWorkbookModule and put it in a general
module.

Then it should work.

You should only put event code in the ThisWorkbook and sheet modules as a
general rule.

--
Regards,
Tom Ogilvy

Hello,

I have a master workbook(1) that opens a second
workbook(2) and I would like to call a subroutine in
workbook(2) from workbook(1). The subroutine will perform
calculations in workbook(2).

I have found a way to do this by manually setting a
reference to workbook(2) in workbook(1), but I'd like to
do it without adding a reference.

When I use the line:

Application.Run("CC.xla!Calculateconfig",var1,var2)

I get an error saying it expects an “=”.

The subroutine I’m trying to call is in a workbook
called “CC.xla”, the “ThisWorkbook” module, and is
named “Calculateconfig”.

Any suggestions?