View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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.