Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a macro from macro
I have this connection
Sub GetconnectionADOBD() Dim cnx As ADODB.Connection Set cnx = New ADODB.Connection cnx.ConnectionString = c cnx.Open If cnx.State = adStateOpen Then End If Application.Run "mymacro,(cnx)" End Sub and this macro has this as argument Sub mymacro (ByVal cnx As ADODB.Connection) ... end sub I have a mistake in application.run and I do not understand why, how can I call macro from macro. Ina |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a macro from macro
Why not just use
mymacro cnx -- HTH Bob Phillips (remove nothere from email address if mailing direct) "ina" wrote in message oups.com... I have this connection Sub GetconnectionADOBD() Dim cnx As ADODB.Connection Set cnx = New ADODB.Connection cnx.ConnectionString = c cnx.Open If cnx.State = adStateOpen Then End If Application.Run "mymacro,(cnx)" End Sub and this macro has this as argument Sub mymacro (ByVal cnx As ADODB.Connection) ... end sub I have a mistake in application.run and I do not understand why, how can I call macro from macro. Ina |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
call a macro from macro
Thanks :)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
Excel Macro call Word Macro with Parameters | Excel Programming | |||
macro call | Excel Discussion (Misc queries) | |||
Macro to call a file that has a auto open macro in the file itself | Excel Programming |