I have an excel file which is in windows explorer has its property set to hidden.
I have another excel file, with some Vba in it, which opens the hidden file, inserts some data into it, saves the file and closes it.
This all works, except that the hidden property is lost in the process.
Is there a way of saving the file, and keeping the hidden property? This is just so that users cant see the file and accidently open it.