[VBA] Need help on (theoretical) how-to add some code into existing one

Hi all,

Prelude : I can't share the file as it contains critical data.

quick rundown on my problem : there is an existing macro that runs fine. We have a special case that isn't properly handled by the current code, as it would require some custom input. The current code concatenates a whole bunch of info to generate csv files and then launch another application to print files, depending on some info from the macro.

How the macro works : it starts with a a choice to make between two mediums ; then we enter an ID. From there, the macro will extract data from two databases. We will determine some priorities, some actions to be undertaken, and finally, the macro will choose a case from a previous input. A CSV is generated, and a link opens an app from which we will use a template, depending on the case we chose earlier. (I hope it's clear)

Where I'm stuck : I'm not sure how to wedge my own code into this. I'm not even sure what best option would be. The CSV won't generate if it doesn't have all info ; however, in some custom cases, we don't have all that info.

I imagined I could create a sort of "fork" in the code, but I have no idea how to execute this, if possible. Can I stop the macro, deviate it, and then say "resume from that point" ?

I know it's cryptic without the file... maybe I can try and edit it completely, but there's still the risk I can let info slip, and we wouldn't want that. I guess I could use any guidance and go from there ? If this post is useless, feel free to disregard/delete it.

Thanks for any help !

Salut !

Originally Posted by eawyne

Prelude : I can't share the file as it contains critical data.

« Pas de bras, pas de chocolat ! »

As you can attach a sample workbook without any critical data but respecting exactly the original layout
and accordingly attach the exact expected result text file
with a crystal clear step-by-step explanation in order there is nothing to guess …

Then please delete this post ; the code is riddled with variables that contain infos and names that cannot be shared. There would be no point for me to expurge it from that data as the code wouldn't even be functionnal or readable.