sassora
07-04-2012, 07:00 AM
Hi all
I have a workbook that I need to save using VBA in two ways. The first is the default type of save, the second is to save a read only copy of the file but in a different location.
The VBA code I am looking for would do something like:
1) save the current file
2) save a read only version
but after the first use this would become
1) save the current file
2) Switch off the read-only in the other closed file
2) Save the contents of the current file over it
4) Reapply the read-only
Is this something you could help with?
I have a workbook that I need to save using VBA in two ways. The first is the default type of save, the second is to save a read only copy of the file but in a different location.
The VBA code I am looking for would do something like:
1) save the current file
2) save a read only version
but after the first use this would become
1) save the current file
2) Switch off the read-only in the other closed file
2) Save the contents of the current file over it
4) Reapply the read-only
Is this something you could help with?