View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default WriteResPassword...

I use the SaveAs method with a WriteResPassword because I only want a select
group to open the saved file on a Public drive. My issue is that I want to be
able to repeat the SaveAs procedure (via programmed code only) when necessary
and the WriteResPassword will not allow this. Is there a code that will allow
this file to be overwritten? My other option would be to program the files
deletion prior to re-posting.

Thanks,

Sam