Application.Run Problem

[MJPPaba]

Hi All,

The following line doesn't seen to work

Sub mdl_GetData()
Application.Run ("'my workbook.xls'.'my sheet'!cmdBtn_Click")
end sub

Several things causing issues here:
1 there are spaces in the workbook name
2 there are spaces in the sheet name
3 the code I need to run is held within a Private Procedure
4 the code is part of a Command button 'Click' event.

the Error I get is:
Runtime 1004 (no surprises there)
the macro in ... cannot be found

Question is, how do I run this code from another workbook.

Any help appreciated.

Cheers

Pabs

 

[SkipVought]

Hi,

Make it easy on yourself and use the SheetCodeName. THe format is

Application.Run ("'my workbook.xls'[red][b]!SheetCodeName.[/b][/red]cmdBtn_Click")

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[MJPPaba]

ta