| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| info mtg criteria from one wkbk to another | Excel Discussion (Misc queries) | |||
| Adding Row on a protected wkbk | Excel Discussion (Misc queries) | |||
| Can't Alt Tab from wkbk to wkbk Help! | Excel Discussion (Misc queries) | |||
| HowTo add and name 2 wks to wkbk | Excel Programming | |||
| Call subs from another wkbk? | Excel Programming | |||
Hybrid Mode
