Running macro from Add-in

Hi,

is it somehow possible to run macro from Add-in? I have some code written in Add-In that has to be used for new data everytime. It is difficult to put it into txt and use InvokeVBA, because it is a huge macro. Any advices how to deal with this xlam file?

@Marek_Matuszak

How’s about Execute Macro activity?

it can not be found :frowning: It says that the macro has to be within the workbook. Macro that is in Add-In is not inside the workbook. I tried “Execute macro”:
image
and “Invoke VBA”:
image

If you want to extract the vba code from your file, you can google for this and find lots of resources to help, i am not sure if you can use this with excel scope to run the macro, if not, you can also convert the file to become regular macro enabled excel file.