G Guest Feb 5, 2004 #1 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.
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 Feb 6, 2004 #2 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.
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.
