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?