Getting data from hidden files and leaving them hidden

Good Afternoon all,
I currently have a program that goes out to different servers and saves the files locally to our server. Then it opens that file rearranges the data I need and copies it into the reports file we need. The files it saves to I would like hidden since nobody should ever manually go into them and they jsut take up space in the folder. However, every time I run my macro when it saves them they are unhidden again. How can I make it so that after the macro runs and gets the data and saves the file it stays hidden.

Please Login or Register  to view this content.

The files I need hidden are the campdata.xls, camppassdata.xls, campeod.xls and camppasseod.xls. They are hidden but when the macro ends they are unhidden.