Export to excel as read only file

S

Stephen

Is there a way to export a query or table to excel and make the excel file read-only? If so, will it be possible to replace this excel file each time I export to it.
 
J

Joe Fallon

You can write VBA code to set file attributes once it is exported.
You can delete a file (or re-name it) in code too.
--
Joe Fallon
Access MVP



Stephen said:
Is there a way to export a query or table to excel and make the excel file
Click to expand...
read-only? If so, will it be possible to replace this excel file each time
I export to it.
 
Top