Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can call a routine in another workbook by doing:
Application.Run "SomeBook.xls!SomeRoutine" Since you can call a routine in a form by: Call SomForm.FormRoutine I was hoping that you could call a form routine from another workbook by doing: Application.Run "SomeBook.xls!SomeForm.FormRoutine" but this doesn't work. Is there a way to do this? On a related note, is there a way to unload a form from another workbook. My understanding is that calling a routine in a form will automatically load it (if it isn't already loaded) but there are times when you would want to unload a form to guarantee you are starting fresh. Denis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calling a routine to declare variables at start of macro | Excel Programming | |||
name of calling routine | Excel Programming | |||
No events in form displayed from callback routine | Excel Programming | |||
Read directly a returned array in the calling routine | Excel Programming | |||
Keep userform visible, but return control to calling routine | Excel Programming |