Invoke VBA activity automatically saves excel file

Help Studio
, , ,
#1

Hi community,

I am using Invoke VBA activity within Excel Activity Scope with Save Changes as not checked. Still somehow it always Saves excel file. I do not want to save every time as file size of excel is crossing 100 MBs and saving this file everytime causes long BOT runtimes.

Please suggest how to achieve this.

#2

Hey @JDoshi

How did you confirm the file is getting saved in the mid run?

Thanks
#nK

#3

It is saving when execution steps out of Invoke VBA activity. It can be seen saving as Visible is marked in the Excel scope activity. Below is snap of the activity and properties.

MicrosoftTeams-image
MicrosoftTeams-image1594×688 105 KB

#4

I am kind of stuck. It would be great if anybody can help related to this. @loginerror @lakshman @uipath @nisargkadam23 @nitya.tomar @radu_bucur @Krutika_Kotkar @Palaniyappan @Parth_Doshi