Use a Pivot Command in Form

Good Morning

I was hoping someone might be capable to assist

I have a form called FrmEmployeeCountPivot

And on the above mentioned i have a subform called FrmEmployeeCountPivotSub

The Sub is a Pivot Table

What i am trying to achieve is normally i will click on my pivot table comandbar, on the export to excell. And will work perfectly.

Now Because the sub is on my main form my Pivot Commandbar, does not appear anymore.

I would like to place the command on my main form to allow the user the send the pivot to excell exactly as it happens if i click the send to excel command on my menu..

Is there a way that use the send to excel menu command just behind an normal cmdbutton on my form

I tried creating a macro that uses
Runcommand - PivotTableExportToExcel but only get an error, action failed
is there a way that i can make use of the command on my subform.

Thank you very much in advance for any help

Regards