run into 1004 error "method 'saveas' of object '_workbook' failed" when saving wb copy

Hi,
I am struggling with Runtime 1004 Error "method 'saveas' of object '_workbook' failed" when trying to save a copy of my workbook. I looked through many of similar posts here, but any solution helped. What I am basically trying to do is to save a copy of my 'master' file every time it refreshes Power Query and connected Pivot Tables... The code stops on .SaveAs line. Please see full code:

Please Login or Register  to view this content.

What is interesting, when I am pressing F8, the code actually saves the file into given location (SharePoint path staring with "https://sp. ..."), so the path seems to be ok.
Any clues what might be wrong here?

Thanks for prompt reaction! Took a chance with SaveAs2, but I am hitting Run-time error '438': Object doesn't support this property or method now. Is it not reserved to MS Word?

any other ideas? [in the meantime I have checked SP permissions, and that is not the issue...]

It is regular Excel macro (xlsm file in MS Excel 2010 64-bit), but suggested SaveAs2 Method is from Word VBA Refrence (library). I still didn't figure out what is wrong with my code.

It seems that some brake was what I needed... after another try my case is solved now. Silly mistake was with the SaveAs path, where I should use backslash instead of forward slash. I have also changed the concept to first Copy than SaveAs my files.

Sure, marked as solved now. Thanks for heads-up and links!