Overwrite a read only file

[drgkt]

Please Login or Register  to view this content.

won't work because somename.xls is ReadOnly.

Any other tricks besides changing the attribute before saving?

thanks

[BillyRaySpivy]

save file as

[drgkt]

I do not get it

[BillyRaySpivy]

click file then save file as then choose a name and location for your new file

[BillyRaySpivy]

If you are still having trouble go ahead and attach the file

[drgkt]

I do not think you understood.

I want to overwrite the somename.xls though is read only via vba

[BillyRaySpivy]

make a copy of it in a file of your choosing and then delete the read only one

[drgkt]

You want to put it in code please?

[BillyRaySpivy]

Keep it simple!

[BillyRaySpivy]

Why do you need code to save a file?

[drgkt]

Because it is part of much longer code

[cytop]

If you are certain you mean the RO file attribute and not that a file is read only because another user/process has it open (in other words, 'Locked') then that is a File System setting. You will have to change the Attribute before the file can be overwritten.

I can't see why you would not want to use SETATTR() to change the attribute.

If the file is Locked rather than just Read Only then SetAttr will also fail - It needs exclusive access to the file, as does any other method of changing the attributes of a file.