Excel Application Scope: Exception from HRESULT: 0xE0000002

Help Studio
, ,
1

Hi Guys - what causes this error in Studio?How can I resolve it?

Thanks,

2

@odure

Try opening task manager and check from background process microsoft excel would be present mostly…kill that and try again

Cheers

3

@Anil_G Done that - there was no excel process in the background.

4

@odure

Is it happening only for one excel?

If so can you please try opening the file …use save as and then save the file with differnet name and check

Cheers

5

Its downloading a file from a site and storing it in a variable then using that excel downloadedFile across the workflow.It has been working fine for the past 2 days post deployment.

6

@odure

Did you use a wait for downlod to make sure the file is competely downlaoded before moving forward

And is there any one drive or so you are using to sownlaod or is it to lcoal only?

Cheers

7

Yes I did - Its downloading to a folder on the server.

8

Capture

9

@odure

Can you please open exception details and check if innerexception provides more details

Better try downloading to local because if on seever because of sync we might face issues

Cheers

10

@odure : Could you please use Excel Kill activity to kill Excel process after that delay of 3 sec & then only use Excel application scope activity & try to do that for each Excel application scope.

11

@avinash_ghanwat1 Yes - I have tried this but the error is still persisting.
@Anil_G So its downloading on the local directory of the server.

12

@odure

Instead of application scope did you try with read range workbook?

Cheers

13

Yes - did so but its still persistent - could the issue be my excel - Ive updated it.

14

@odure

If it is happening with every excel then yrs it might be with application

If its with specific excel then you need to try with a different downlaod again…

Cheers

15

Turn out the issue was with the xlsm file that was loaded.After testing with a different file - its working just fine.

1 Like
16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.