Save filename without the user being able to change the filename?

[geralf]

Hi,
I'm transfering records from Acces to Excel (using the Excel 9.0 library - not TransferSpreadsheet Method). The filename of the workbook is construv\cted based on month and year, for instance Feb2003.xls

If the file don't exist, I'd like it to be created, but without the user being able to change the filename. Can this be done, and if so how?

All has to be done from Access VBA.

Thanks in advance for any help


Regards
Gerhard

 

[John.Woody]

You could create the file and set the properties to read only. Its not permanent but it may be enough.