Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there an alternative to Application.Run
I'd like to call sub routines that reside in another workbook. I know about
application.run but if I want to pass arguments byref it doesn't seem to work (i.e. the changed value is not passed back). In the Vb help on calling procedures with the same name there's this example:- Sub Main() [MyProject.vbp].[MyModule].Main End Sub I've tried renaming projects and using this:- Sub Main() [MyProject.xls].[MyModule].Hello End Sub ...but can't make it see my hello procedure. Where am I going wrong and once right will it allow me to do things like this:- Sub Main() a = 1 b = 2 [MyProject.xls].[MyModule].Swap(a,b) msgbox ("Swapped " & a & "," & b) End Sub Any help much appreciated! J.P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alternative add-on application to VLOOKUPS command? | Excel Discussion (Misc queries) | |||
Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
Alternative to Application.FileDialog (please)? | Excel Programming | |||
Alternative to Application.Match | Excel Programming | |||
Alternative to Application.Match | Excel Programming |