View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan P Alan P is offline
external usenet poster
 
Posts: 23
Default Saving with password

I have files that I need to save with a passord each month. I'd like to
automate this as the password will be the same. The location (of all the
files) will be different each month, so using SaveAs won't help too much
unless I want to change the code each month. I tried ThisWorkbook Save and
ActiveWorkbook Save and they didn't work with Pasword. Anyione have any
thouhts?

Thanks,

Alan