run a procedure in 1 wkbk from another wkbk
 

I am trying to have my procedure open up another workbook file and
then my procedure needs to run procedure(s) in the the opened file then
return control to my main procedure.

Below are the call statements I have tried along with their error messages:

Call cmdRetrieveData1_Click (error: sub or function not define)
(but it is defined in the other open workbook and the name is correct!)

Call [Newfile.xls].[Newfile.vbp].[Module4].cmdRetrieveData1_Click
(error: subscript out of range)

Help! I need to resolve quickly.

run a procedure in 1 wkbk from another wkbk
 

Application.Run "OtherBook!myMacro.xls"

--
HTH

Bob Phillips

"carenla" wrote in message
...
I am trying to have my procedure open up another workbook file and
then my procedure needs to run procedure(s) in the the opened file then
return control to my main procedure.

Below are the call statements I have tried along with their error
messages:

Call cmdRetrieveData1_Click (error: sub or function not define)
(but it is defined in the other open workbook and the name is correct!)

Call [Newfile.xls].[Newfile.vbp].[Module4].cmdRetrieveData1_Click
(error: subscript out of range)

Help! I need to resolve quickly.