topic Re: Clearing Excel Cache using Code Stage in Product Forum

Clearing Excel Cache using Code Stage

BernardoCris012 — Thu, 23 May 2024 00:35:34 GMT

I came accross this article on clearing cache files in excel using VBA, is there a way we can create action similar to this one in Blue Prism? Would it be benificial for the process?

Re: Clearing Excel Cache using Code Stage

Neel1 — Fri, 24 May 2024 13:36:33 GMT

also, below setting can be explored in Excel Setting on Virtual Machine.

Re: Clearing Excel Cache using Code Stage

harish.mogulluri — Fri, 24 May 2024 16:41:38 GMT

Hi ,
It is VBA code, Definitely you can use code stage and create action and use it in the process

Re: Clearing Excel Cache using Code Stage

BernardoCris012 — Tue, 04 Jun 2024 03:25:49 GMT

Thanks! Been trying this for a week now, there's a significant improvement with the process.