Skip to main content
Hi,

I'm trying to create a kind of menu, listing all the available macros we have, so my users can pick the one they want to execute.

I've put all the macros name with the sub to call in a picklist. when the user select a macro, I'm trying to call the associated function but a "Call myFileName" does not work.

I've seen some notes in various web side suggesting to use "Application.run" but I receive a "Run-time error '438' - Object doesn't support this property or method). I think this will only work for Excel, Word and Access...

I'm running out of idea now so any trick would be appreciated?

#Reflection
Hi,

I'm trying to create a kind of menu, listing all the available macros we have, so my users can pick the one they want to execute.

I've put all the macros name with the sub to call in a picklist. when the user select a macro, I'm trying to call the associated function but a "Call myFileName" does not work.

I've seen some notes in various web side suggesting to use "Application.run" but I receive a "Run-time error '438' - Object doesn't support this property or method). I think this will only work for Excel, Word and Access...

I'm running out of idea now so any trick would be appreciated?

#Reflection
Sylayo,

I am not sure what version or edition of Reflection you are referring to here nor what type of Macro. If you are referring to VBA Macros, have a look at the VBA Programming Guide. If you need help with troubleshooting, it is better for you to contact our support team via email.

Thanks,
Jeff
Terms & ConditionsAccessibility statement