The error in your code is the two Sub lines. It should look like this:
Private Sub CommandButton1_Click()
As for the second, if you record a macro opening up another wb, VBA will record the correct file path (location) and syntax for you. You can then draw a button on the sheet from the Forms toolbar. As soon as you're done drawing it, you'll get a menu dialog. One of the options is Assign Macro. Select the recorded macro. Now when you click the button, the macro will fire.