CommandButton Link to Macro

How do you link a Macro to a CommandButton.

Right now when I click on the button in design mode it references a
macro on the worksheet I am working on and it is trying to reference
another Macro. The macro is stored in a different file in another
directory. What is the file path to reference a Macro somewhere else?

So far my code in the commandbutton looks like this, but it doesn't do
anything when I click the button. I am missing some part of the path
to find the Macro. Can anyone help me?

Private Sub File_Updated_Click()

Public Sub Fileupdate()

End Sub

Thank you for your help!
Kristina

You can run a macro in another file using:

Excel.Run "<file>!<macro>"

where you replace <file> with the filename and <macro> with the macro
name.

However, I think the file already needs to be open in Excel, so you
will probably need to do that in your code also.

The easiest thing you can do is to
(a) create an object instead of a button within the file you have the macro
stored. This can be a rectangle, that looks like a CommandButton, but it is
actually a rectangle object.
(b) you assign the required macro to this object
(c) you then copy and paste the object into the file you want to start the
macro from

In case the file with the macro is not open when the user hits the pseudo
'button', excel will open the file for the user to run the macro.
Hope this is an option, at least it works fine for me in '97.

Gabor


"KMassey1976" <[email protected]> az alábbiakat írta a következo
hírüzenetben: [email protected]...
> How do you link a Macro to a CommandButton.
>
> Right now when I click on the button in design mode it references a
> macro on the worksheet I am working on and it is trying to reference
> another Macro. The macro is stored in a different file in another
> directory. What is the file path to reference a Macro somewhere else?
>
> So far my code in the commandbutton looks like this, but it doesn't do
> anything when I click the button. I am missing some part of the path
> to find the Macro. Can anyone help me?
>
> Private Sub File_Updated_Click()
>
> Public Sub Fileupdate()
>
> End Sub
>
> Thank you for your help!
> Kristina
>