How do I save a file as non-read only from a read only

[tomneedshelp]

I have a macro that saves a copy of a read only file. Which works great except it saves the new in read only mode. I have spent several hours searching the net but have struck out. Appreciate the help.

Please Login or Register  to view this content.

[6StringJazzer]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[tomneedshelp]

Learned something new again - Thanks

[6StringJazzer]

If the rule for code tags is new to you, then please take the time to review our rules. There aren't many, and they are all important.

The Read Only attribute is a Windows file system attribute, not an Excel attribute. When you use the xlDialogSaveAs dialog box, you lose control over how this file is saved. You can use SetAttr to turn of the Read Only after the file is saved. With the save method you have used, the active workbook's name is changed, so it is easy to reference it and reset the Windows attributes:

Please Login or Register  to view this content.

[tomneedshelp]

Worked great - Thanks you