Can VBA copy data from an Excel Sheet to a *.csv workbook which is not open?

Originally Posted by Elijah

... you're referring to VBA specifically?
... other software updating ... *.csv file while it's closed

Not only, it's just your illusion. Every disk file, in order to write something in it, must first be opened with the appropriate mechanism of a given program, that does it. Only the GUI of this mechanism of this program is not always visible.

Originally Posted by Elijah

... I found some links here which should be helpful ...

Did you look for it on the forum? A lot of this should be here.