Export to excel as read only file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
How to Convert EML to PST? 2
Exporting Query Results to Excel File AND Setting File as READ ONL 2
Can't export to EXCEL file 1
Exporting to Excel 2007 1
Exported Excel File is Incomplete 14
Best third-party tool to repair OST files 3
Exporting several queries into Excel 1

Back
Top