Activate Macro - External Program

Good Morning Everyone,

I have a macro that opens a file and CSV formats.
I run a function in my other program that calls the macro XLA. But the macro does not run.
What do I need to run the macro when the call is for external program?
My macro has one Sub and two Private Function. The Sub is the first. Its correct? I tried Sub and Function, but doesnt work.

Tks everyone

Hugs
Caio

you need something to start the code running in the workbook open event

I am not grasping the context.

Which program/workbook is doing the opening?
Which program/workbook macro is supposed to fire that does not?

Can you describe the order of your events and what program/workbook is doing these?