Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Form Routine from Another Workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Form Routine from Another Workbook
1.
Application.Run "SomeBook.xls!SomeForm.SomeRoutine" Put code in SomeRoutine to run (ie load and show) the form (in same project as SomeRoutine) 2. Yes you are right, as soon as you reference a userform it will load into memory and stay there until explicitly unloaded (or the wb is closed) To unload one or all forms in a project - Dim i as long For i = 1 to Userforms.count To 1 Step -1 ' If Userforms(i - 1).name = "myFormName" Then '' only unload this form Unload Userforms(i - 1) ' End If Next uncomment "If..." & "End If" to only unload a particular form, if loaded Regards, Peter T "Denis" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |