Is initial save to local drive more resilient than using network drive

I would like to create 100 different reports - they all need to initially be saved to one location - then they need to be distributed to various locations on our network drive.

An Excel vba program is creating the files from an xlsm file saved on the network drive.

Which of the following approaches is more resiliant/defensive?

1.Save 100 files to C-Drive of machine running the code - then distribute to 100 different locations on the network drive. 2.Save 100 files to same network location where controlling xlsm file is located - then distribute to 100 different locations on the network drive.