Simon has attended:
Excel VBA Intro Intermediate course
Cannot SaveCopyAs to another folder
Dear Sir/Madam,
I am using the SaveCopyAs method to save a copy of a spreadsheet to another location which is in another folder.
When I run the procedure, it opens the spreadsheet but then produces an error message :Run Time Error 1004, Cannot access read-only document 'folder name".
Is there any way around this. If you right click the folder and go to properties and un-check Read-Only then go back to properties, the box is checked again.
Any help would be appreciated.
If you need any more info please let me know.
Kind Regards,
Simon.
RE: Cannot SaveCopyAs to another folder
Simon
You need to add the following codeline to your code
ReadOnlyRecommended:=False
This deselects the ReadOnly option
Carlos

