topic RE: How to disable Autosave in Excel via VB.net code in Product Forum

How to disable Autosave in Excel via VB.net code

AP.Philippa — Thu, 17 Sep 2020 09:37:00 GMT

Hello BP community!

We recently have run into an issue with the Autosave-feature in Excel. When dealing with Excel documents located on a SharePoint website, we have noticed that the Autosave-feature is turned on by default. I can understand that is great for the human co-worker, however for the robot this is not ideal as you may not want to save your changes all the time. It would therefore be great if the robot is able to disable the Autosave-feature in Excel when desired (ideally via a code stage which can be added to the Excel vbo). Does anyone already have had success with dealing with the Autosave-feature in Excel and how did you guys get around this?

Thanks in advance!

------------------------------
Arthur Philippa
RPA Developer
Port of Rotterdam
Europe/Amsterdam
------------------------------

RE: How to disable Autosave in Excel via VB.net code

AndreyKudinov — Thu, 17 Sep 2020 09:44:00 GMT

https://support.microsoft.com/en-us/office/what-it-administrators-should-know-about-autosave-88e0f80f-e5ea-441b-9c5a-259f08490ae7?ui=en-us&rs=en-us&ad=us

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------

RE: How to disable Autosave in Excel via VB.net code

PritamPoojari — Thu, 17 Sep 2020 14:39:00 GMT

Hi
Instead of updating the file in SharePoint directly, can the robot download copy of the excel file on the machine, manipulate it and then upload it to SharePoint?

------------------------------
Pritam Poojari
Solution Architect
Capgemini
Europe/London
------------------------------

RE: How to disable Autosave in Excel via VB.net code

shashank.kumar280 — Fri, 18 Sep 2020 04:26:00 GMT

Hi,

The programmatic way to disable AutoSave for a specific workbook would be to set the AutoSaveOn Flag to False

ActiveWorkbook.AutoSaveOn = False

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: How to disable Autosave in Excel via VB.net code

AP.Philippa — Fri, 18 Sep 2020 08:24:00 GMT

Hi Shashank,

Many thanks for your input!

Just tested the code and I was able to get it working!
I now have created a code which can toggle the AutoSave On or Off depending on a flag provided in the code input and added it to the Excel vbo.

For who is interested, the code is as following:

Dim wb as Object
Dim excel as Object

Try
wb = GetWorkbook(handle, workbookname)
excel = wb.Application

wb.AutoSaveON= Turn_AutoSave_ON

Success = True

Catch e As Exception
Success = False
Message = e.Message

Finally
wb = Nothing
excel = Nothing
End Try

Cheers!

------------------------------
Arthur Philippa
RPA Developer
Port of Rotterdam
Europe/Amsterdam
------------------------------