ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   WriteResPassword... (https://www.excelbanter.com/excel-programming/427643-writerespassword.html)

Sam

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


All times are GMT +1. The time now is 10:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com