Hello,

I have a report that is saved on a Sharepoint site. The Macro is a Workbook_Open macro. I would like, at the end of the macro, for it to

- Save back to the same location on the sharepoint site
- Replace the old file
- Not have the user prompted at all

any thoughts?

Thank you