Run A Macro

[JoanaChang]

I have problem using the runmacro function!
this two macros are in the same place ("new macros")

when I tried to do this:

Public Sub borrarTODO()
.....
runmacro ("temporal.CrearHOJAnueva")
End Sub

Public Sub CrearHOJAnueva()
...
End Sub

It appears a compile error, "Sub or Function not defined"
What am I doing wrong?

I need examples about runmacro function

Thanks!
Joan

 

[JuneTheSecond]

You would not beed RunMacro function in VBA.
Simply state macro name.
RunMacro function is a function to be used in shapesheet.

 

[David Parker]

If you are trying to run a function that is in another VBA Project, then
check out ExecuteLine method