How do I stop a macro keep repeating its self.

[ghrek]

I have this code in the area called "this workbook"

Private Sub Workbook_AfterSave(ByVal Success As Boolean)

Call Macro1
End Sub

And this is macro 1

 ActiveWorkbook.SaveAs Filename:= _
"https://xxrivagroup.sharepoint.com/teams/PASSACC/Shared%20Documents/General/shrek%20summary.xlsm" _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
ActiveWorkbook.Save
    ActiveWorkbook.Close

The issue I have now is that the macro keeps on repeating its self and saving all the time and the only way out is to push esc key. Is there anyway round this?

Thanks

 

[Joe4]

I have not worked with Sharepoint at all, so I cannot really over any advice on that.
I would recommend starting a new thread on that, since it is a new question.

 

[ghrek]

Ok big thanks

 

[JLGWhiz]

You might want to specify where you are starting from. That is, are you updating the file while on the sharepoint server, then saving the remote file before saving the local file. You might need to include a ChDir command in your code to bring the active directory back to your system, or use the full name (including path) for each save action. That was not made clear in this thread.

 

[ghrek]

You might want to specify where you are starting from. That is, are you updating the file while on the sharepoint server, then saving the remote file before saving the local file. You might need to include a ChDir command in your code to bring the active directory back to your system, or use the full name (including path) for each save action. That was not made clear in this thread.

Apologies. In response to comments

I explain on what I’m trying to do that may be easier as a novice.

I have the document on a local file and when I save it creates a sharepoint file with same name and saves there as well as saving locally.

That bit I have in the macro already and is fine.

What I’m then trying to do is after I have added data to the local file after originally saving and reopening later I need it to again save locally and to sharepoint but NOT create a new file in sharepoint but overwrite the existing file that is there.

Doesn’t matter which way round it saves it sharepoint first then locally or VV as along as saved to both.

As far as your remarks about Chrdir yes I know it means chain directory but what it does or where it goes into got a clue.

Hope that helps

 

[JLGWhiz]

Then you should be able to open your local file, make your changes and do a normal save. Then do a SaveAs using the path to the share drive file and when you get the "File Name Already Exists" message, just answer it with yes to overwrite the share drive version.