Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving A Read Only File?
Is there a way using VBA, to save an open workbook that is read only? I
can't seem to find any info on this at all. Thanks, Todd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving A Read Only File?
How about using saveas something like:
Sub SaveMe() Dim flname As String Dim fullName As Variant Dim filter As String flname = "SaveName" filter = "Excel Files (*.xls), *.xls" fullName = Application.GetSaveAsFilename _ (flname, filter, , "MyFile") If fullName < False Then Application.DisplayAlerts = False ThisWorkbook.SaveAs fullName Application.DisplayAlerts = True End If End Sub Hope this helps Rowan TK wrote: Is there a way using VBA, to save an open workbook that is read only? I can't seem to find any info on this at all. Thanks, Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read only vs file saving | Excel Discussion (Misc queries) | |||
Saving over a read only file | Excel Programming | |||
Urgent problem saving a file read only | Excel Programming | |||
Saving it as read only? | Excel Programming | |||
Saving a file within a macro but only when it does not have a read only attribute | Excel Programming |