Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
call function from another wb : problem
Hello,
This is the situation Function UpdateMb <instructions application.run(<workbookname!<modulename.<functi onname()) <instructions End function When the application.run cmd is running, there is no runtime error. However the function UpdateMb is rerun immediately without having run the function from the other wb. Thanks for your help Francois. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
call function from another wb : problem
Hi Francois,
Have you tried stepping through your code. Put a break point F9 on the first line in UpdateMb, or the single statement "Stop" without quotes. When the code stops press Ctrl-L to see what called the function. Step through with F8 or run to the next break or stop statement with F5. (Also look at Ctrl F8, Shift F8 & Ctrl+Shift F8) Off topic - did you sort out the problem you posted a while ago re showing an Application.Dialog called from Macro-5 dialogsheet code. Regards, Peter T "François" wrote in message ... Hello, This is the situation Function UpdateMb <instructions application.run(<workbookname!<modulename.<functi onname()) <instructions End function When the application.run cmd is running, there is no runtime error. However the function UpdateMb is rerun immediately without having run the function from the other wb. Thanks for your help Francois. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
call function from another wb : problem
Also - it didn't occur to me this might be a UDF. If it is, include the
following line just before the break point: Debug.Print Application.Caller.Address Ctrl-G to see the Immediate window. Peter T "Peter T" <peter_t@discussions wrote in message ... Hi Francois, Have you tried stepping through your code. Put a break point F9 on the first line in UpdateMb, or the single statement "Stop" without quotes. When the code stops press Ctrl-L to see what called the function. Step through with F8 or run to the next break or stop statement with F5. (Also look at Ctrl F8, Shift F8 & Ctrl+Shift F8) Off topic - did you sort out the problem you posted a while ago re showing an Application.Dialog called from Macro-5 dialogsheet code. Regards, Peter T "François" wrote in message ... Hello, This is the situation Function UpdateMb <instructions application.run(<workbookname!<modulename.<functi onname()) <instructions End function When the application.run cmd is running, there is no runtime error. However the function UpdateMb is rerun immediately without having run the function from the other wb. Thanks for your help Francois. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
call procedure problem | Excel Discussion (Misc queries) | |||
Is there a do not call function? | Excel Discussion (Misc queries) | |||
how i can call the function | Excel Worksheet Functions | |||
Function Call | Excel Programming | |||
call function | Excel Programming |