WriteResPassword...

S

Sam

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
 

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

Simplify save code 11
How do I convert a macro that was created in 2003 Excel to 2007 8
Server side permissions for SaveAs 0
SaveAs macro: How do I specify "Replace existing file?" 1
Saving Problem 5
Protect a Workbook 3
Can not save excel files through stored procedure on Server 2008 1
Problem with Upload Center on Office 2010 when using encrypted area on disk 0

Top