VBA code to execute a module in a different workbook

Thanks for the responses.
It seems to work fine except if the file has spacings in its name.
I don't know if that's the reason it don't work in those cases or if there's another reason.
I just noticed it only happened so far when the file has spacings in its name.

The error I get says something about macros disabled. I checked but all macros are enabled.

See the attachment

untitled.jpg

it's definitely the space in the name
(when i removed it the code worked fine).

So my question is what to change in the code to make it working for files with spaces in their name also.

Thanks in advance

Made some changes to the code so I could put the file name between an extra pair of single quotes ' ' to deal with spaces and "-" in file names:

Private Sub CommandButton1_Click()
    Workbooks.Open ("\\Nw_edc_02\apps1\Starquery\Werkfolder\WR\xls\aantal picks.xls")
    Application.Run ("'aantal picks.xls'!Updbtn_Update")
End Sub

Found here: http://stackoverflow.com/questions/2...ontains-spaces