How to run a sub from another open workbook?

[Jaymond Flurrie]

I have a workbook LF-9.xlsm and I have "Public Sub RunLogic" there. How do I run it from another open workbook? I tried
Application.Run ("LF-9.xlsm!RunLogic")
but it says "Run-time error '1004': Cannot run the macro 'LF-9.xlsm!RunLogic'. The macro may not be available in this workbook or all macros may be disabled"

I tried to run it directly from the mdlSolverPart -module in that LF-9.xlsm workbook, and it has no problems at all. Running "internal" code in the calling workbook, UI-12.xlsm works without problems as well.

I'm using Excel2010.

 

[Jaymond Flurrie]

Anyone? I don't think this is as impossible as it seems to me right now.

 

[Jaymond Flurrie]

It doesn't seem to work for other macros in that workbook either. It shouldn't be about macro protection either, since I have enabled all macros (ie. disabled the whole security system).

 

[xenou]

It appears the hyphen in the filename is the problem. Try single quotes around the name:
Application.Run "'LF-9.xlsm'!RunLogic"

You can also set a reference to LF-9.xlsm in the VBE if its a stable file name and location - under Tools | References. But you must give the vb project a unique name first under Properties (other than the default "VBProject").

 

[Jaymond Flurrie]

It appears the hyphen in the filename is the problem. Try single quotes around the name:
Application.Run "'LF-9.xlsm'!RunLogic"

You can also set a reference to LF-9.xlsm in the VBE if its a stable file name and location - under Tools | References. But you must give the vb project a unique name first under Properties (other than the default "VBProject").

Thank heavens I went to sleep before forcing everything into a single file, you have no idea how much this helps me! The fact is that I have a deadline with this project tonight and the chance to save like a couple of hours now because of your help increased the chances to get this done on time dramatically.

Please tell me if there's anything I can do for you.

 

[xenou]

No worries. Good luck!