VBA macro to create a copy of a file as CSV format

Hello all,

I really hope to find a solution to a tricky task.

I have to work in a shared excel sheet with a few people editing it.
What I am looking for is a macro, that when updates are ready to go, changes are safed as XLSM and a copy of what's been done as .csv file in the background. I want to stay in the is excel sheet and continue working and do the updates when needed the same way later.
The macro should be available for every user.

Is this possible?

I need the csv file as we are running a script were xls is not allowed. But csv does not allow to share etc.
Any questions, please ask.

Thanks for your input, stay safe,
2Dizzy

Hi,

you can even operate manually just with the Save As Excel feature selecting the CSV file type
or if really you need a VBA procedure use the Workbooks.SaveAs method …

Hi Mark,
,
the problem I have when saving as, is that it leaves me in the csv file, but I need to stay in the excel sheet
and continue working while the csv file can be accessed by the scipt.

Thanks,
2Dizzy

So the kid logic says to just start with the Workbooks.SaveCopyAs method to create first a temporary workbook
then open this temp workbook then SaveAs CSV then close, that's all folks !