View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
edward edward is offline
external usenet poster
 
Posts: 87
Default protecting a file

Hi everybody,
I've written some VBA code to send certain data to an Excel file which
somewhere in our network, I deally I want to make the file Read/write
protected and only accessable through VBA . Something like remove read only
property anytime I want to send a new record to Excel and after I finish the
process then make it read only again.
What is the best way of doing this?
--
Best regards,
Edward