Set automatically generated csv file to be shared

Hi, programming experts!

I have a csv file with process parameters automatically generated by a machine. The file is created on a new day when the first run is made on machine. Afterwards the machine appends data to the file as new runs occur.
I want to create a dashboard in Excel updated frequently to keep track of process parameters. Everything seems straightforward but I cannot seem to share an csv file.
My questions are:
How do I make a csv file shared?
How do I repeat the attempt to make it shared if, during my attempt to make it shared, the file was accessed my machine trying to append a new record to the file?

As I see the only plausible option for now is to create a shared Excel copy of the csv file and work with it, but this seems to be a bit awkward solution.

I would very much appreciate your assistance with this.

Regards,
Dmitry

A csv file is just a text file really so I don't see that you will be able to allow shared access to it as such.

Dom

You're not actually saving it as a csv file. You're saving an Excel file and just calling it a csv file name which is different. You need to specify a csv format if that's what you require but it won't be able to be shared I don't think.

Dom

Sounds like you need a database rather than a spreadsheet.

Dom