Hi
I have this macro and when I try to open and automatically not come up as read only it keeps telling me that its locked for editing and do I want to open as read only or save and edit a copy. The thing is that the person it says that has it open has not got it open ?
Looking at it to I think I got it as a save as too rather than a open.
Any Ideas?
'
I have this macro and when I try to open and automatically not come up as read only it keeps telling me that its locked for editing and do I want to open as read only or save and edit a copy. The thing is that the person it says that has it open has not got it open ?
Looking at it to I think I got it as a save as too rather than a open.
Any Ideas?
'
VBA Code:
' Macro9 Macro
'
'
ActiveWorkbook.SaveAs Filename:= _
"https://rivagroup.sharepoint.com/teams/LOOMISGROUPVISITSISSUES/Shared%20Documents/General/Loomis%20Missed%20collections.xlsm" _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
End Sub