Denverhoss
05-09-2016, 08:31 AM
Hi experts!
I built a macro that does automatic backups of the current PowerPoint presentation when a timer expires. Normally it works fine, but sometimes PP crashes. In one instance I was resizing an object and got a save error and crash, another time I was doing a manual SaveAs at the same time the automatic savecopyas triggered and PP crashed and restarted with no error message. Is there a way to make the background save an exclusive task? Has anyone seen this type of issue before? I didn't find anything that sounded like this issue when I searched. Thanks!
BSave1 = LocalFold & "\" & ActivePresentation.Name & "_Backup" & Format(Now(), "YYYYMMDDhhmmss") & ".pptm"
PowerPoint.Application.ActivePresentation.SaveCopyAs BSave1, ppSaveAsOpenXMLPresentationMacroEnabled
I built a macro that does automatic backups of the current PowerPoint presentation when a timer expires. Normally it works fine, but sometimes PP crashes. In one instance I was resizing an object and got a save error and crash, another time I was doing a manual SaveAs at the same time the automatic savecopyas triggered and PP crashed and restarted with no error message. Is there a way to make the background save an exclusive task? Has anyone seen this type of issue before? I didn't find anything that sounded like this issue when I searched. Thanks!
BSave1 = LocalFold & "\" & ActivePresentation.Name & "_Backup" & Format(Now(), "YYYYMMDDhhmmss") & ".pptm"
PowerPoint.Application.ActivePresentation.SaveCopyAs BSave1, ppSaveAsOpenXMLPresentationMacroEnabled