Hi, here is a little problem i have. several people have an own excelsheet open (not a shared one, so each has a unique excelsheet). we need each of these users to copy paste some data from their excelsheet to a CSV file. Each person pastes his data to a fixed line in the CSV (same line, so overwriting the old data) The frequency is once per minute I like to capture this in VBA code Is there a way to do this without opening the CSV file so multiple users, as i imagine simultanously accessing would crash it? hopefully a readeer could help me out with some VBA code! Thanks a lot!! PS the CSV file is used by another user which pulls the data each minute and graphs it. That's why the data in the CSV file can be overwritten each minute.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

multi Excelusers copypaste data to closed CSV file

Thread starter supervink
Start date Jun 23, 2011

supervink

New Member

Jun 23, 2011

Hi,
here is a little problem i have.

several people have an own excelsheet open (not a shared one, so each has a unique excelsheet).
we need each of these users to copy paste some data from their excelsheet to a CSV file.
Each person pastes his data to a fixed line in the CSV (same line, so overwriting the old data)
The frequency is once per minute
I like to capture this in VBA code

Is there a way to do this without opening the CSV file so multiple users, as i imagine simultanously accessing would crash it?

hopefully a readeer could help me out with some VBA code!
Thanks a lot!!

PS the CSV file is used by another user which pulls the data each minute and graphs it. That's why the data in the CSV file can be overwritten each minute.