Run-time error '1004

[abarnes]

Hi there

I have a pretty simple macro which is sporadically working and is intended to save a macro enabled workbook to a SharePoint site, based on a file name in cell H36.

Pretty strange how sometimes it works but wondering why it is falling over?

Any help much appreciated.

 

[gordsky]

I would try changing ActiveWorkbook to ThisWorkbook in case the workbook isnt the active one at the time of save.
I would also tied down the "filename1" by adding the sheetname to the range reference

 

[abarnes]

I would try changing ActiveWorkbook to ThisWorkbook in case the workbook isnt the active one at the time of save.
I would also tied down the "filename1" by adding the sheetname to the range reference

Thanks gordsky

 

[gordsky]

Thanks gordsky

no problem has that solved your issue?