Enabling Read/Write Permissions

Gtabtr1

New Member
Joined
Feb 15, 2017
Messages
33
I have vba code that performs a Save As, creating and naming new files. The new files should not have any read/write restrictions. They should be available for anyone to open, read and make changes. What should the code say to remove read/write restrictions on the new files?

Thank you
 

mrmmickle1

Well-known Member
Joined
May 11, 2012
Messages
2,453
Here are a few examples of how SaveAs Works.

VBA Save File - 20 Easy Examples - VBA Code Examples

If you are trying to save a file that is currently password protected you can use a blank password argument i.e.

Code:
Password:=""
For Write Reservation Password Argument is:
Code:
[I]WriteResPassword:=""[/I]
Here are the arguments to the SaveAs Method: Workbook.SaveAs Method (Excel)

maybe try something like this:

Code:
ActiveWorkbook.SaveAs Filename:="My Filename", Password:="", WriteResPassword:=""
 

Forum statistics

Threads
1,085,334
Messages
5,383,029
Members
401,812
Latest member
topherj09

Some videos you may like

This Week's Hot Topics

Top