Cannot find macro error when running a macro from a macro in a diffrent workbook.

So what this macro is doing first it starts off by selecting the location and filename of the workbook that its going to open, and then opens that workbook. After that is complete it runs another macro named Kazoo which loges into Essbase(Database server). After it logs you into essbase it selects the new workbook that was just opened and looks for the macro "cmreport." This is where we run into an issue we keep getting error message saying that it cant find the macro. Please review when you get a chance and let me know thank you so much for your time.

Please Login or Register  to view this content.

Here is the code for the Kazoo Macro:

Please Login or Register  to view this content.

I know that the macro "cmreport" in the second workbook I am trying to open works.

Does the WorkbookName variable include the extension?

Note: please use code tags, not quote tags, when posting code. I've altered them for you on this occasion.