Excel Activity -- COM

Help Studio
, ,
9

Hi

When you are using excel file for multiple times in short span of time within the process then there are two ways to handle this

  1. Use workbook activities instead of excel application scope and other excel activities

Search as workbook and you can see same set of excel activities which actually doesn’t rely on excel application which is why you get this error on being used frequently along the process

  1. Or use multiple delay Activity and KILL PROCESS activity with ProcessName property as”Excel”

Use this kill process between each excel application scope activity

If it just one excel scope and has multiple other activities inside that scope then use delay activity between each of them with timestamp of around 00:00:05

This will avoid sudden usage of application and reduce the error occurrence

Cheers @Purva

3 Likes