Hi Everybody,

I got a couple of questions about VBA. I tried to understand how the
macro ran in a very complicated worksheet. I need to save two
different ".dll" files in the C drive in order to run the macro. My
first question is: How can I read the ".dll" files? How can I know
when the macro uses them? Any software needed to be installed so as to
open them?

The macro is very long and split in different modules. My second
question is: How to read which modules run first? To be more
specific, how to read the "work flow" of the macro (step by step)?

Also, I would like to know whether any functions in Excel or VB editor
can allow me to read the actual values of the variables when the macro
is running (Of course, the macro is paused when I am reading the
values.).

Any suggestions or ideas are very welcome. Thank you very much in
advance!

Best regards,
S.