Calling Procedures From Other Workbooks

[sachin.acharya]

Hi all,

From within the code in an Add-In I am trying to call a procedure from the ActiveWorkbook. So my code looks somewhat like:

Sub MyProcedureInAddin()
  'My code here...
  Run ActiveWorkbook.Name & "!SomeProcedure"
  'My code continues...
End Sub

This works fine if ActiveWorkbook.Name does not have spaces. But say if my ActiveWork.Name is "Blah Blah Blah.xls" it gives the error:

Cannot run the macro 'Blah Blah Blah.xls!SomeProcedure'. The macro may not be available in this workbook or all macros may be disabled.

Is there a way around this so that I don't have to rename or save the active file without spaces?

Thanks.

 

[GTO]

You know how excel tacks the brackets around the address to links? Try building a string variable that equates this. As I recall, the brackets being there when un-needed do no harm, but are required when the filename has spaces.

Mark

 

[Domenic]

Try...

Run "'" & ActiveWorkbook.Name & "'!SomeProcedure"

 

[GTO]

Yikes! Thanks Domenic

 

[sachin.acharya]

Try...

Run "'" & ActiveWorkbook.Name & "'!SomeProcedure"

Fantastic!!! That works..

Thanks