Is there any way to have a maco click a command button
 

Is there any way to have a maco click a command button in another spreadsheet?
I have a spreadsheet that was designed by an outside source, and I cannot
view his/her code or assign a shortcut key. I have tried to record a macro
to open the other file and click the button, however it does not work. Any
help would be great.

Thanks