Creating a Macro to save a copy before close

I am trying to create a macro to copy the current sheet and save it in a csv formatted version and insert such macro in a "before close" sub.

I have managed to create the macro that creates the csv version successfully however it does not work when I insert it in the before close sub since it is creating a blank copy only.

Below please find the macro to create the csv version:

Please Login or Register  to view this content.

Below please find the macro to create the csv version before closing:

Please Login or Register  to view this content.

Has anyone ever tried something similar and have any idea how to successfully execute the above mentioned macro before closing?

Try this:

Please Login or Register  to view this content.

You will have to keep the macro in standard module and call it using a BeforeClose Event.