Delete recently downloaded file

Help
1

Hi All, can anyone help on this error?

Background: I have downloaded a csv file and save it as excel workbook format. Then using excel application activity I copied the data from that saved excel file to another excel file (my working file). Now the initially downloaded and saved file needs to be deleted.

Problem: the delete file activity is not working and prompting below error:

image
image1920Ă—989 108 KB

Thanks in advance:)

2

@HILOMAP
Is the original file still open when you are trying to delete it? That error message means that another process is actively using that file. This is usually because it is still opened.

3

@HILOMAP

Use Kill Process activity and specify process name as “excel” to close all opened excel files and then use Delete activity.

4

actually when i run the bot without the delete activity, all the files automatically save and close. But when I added the delete activity and re-run the bot, the excel file i am trying to delete retains open and thus, prompting tat error…

5

would there be a chance to select only a specific “excel” to be killed?

6

@HILOMAP
Are you deleting it inside the scope that you are using it? The delete needs to be outside of the scope.

7

yeah it’s outside

image
image573Ă—648 37.5 KB

8

@HILOMAP
Can you remove the delete and pause the robot at the point where the delete would be. Then check task manager to see if there are any excel processes in the background.

9

sorry how can i pause it before it gets to the delete activity?, if remove the delete activity the process ends…

10

Just put in a message box with some blank text, it’ll pause the bot until you click Ok.

11

okay:)

12

it still retains open, and yeah there is an excel application running (that file)

image
image1675Ă—954 86.5 KB

image
image1831Ă—959 120 KB

13

see below screenshot…

14

Try using a Close Workbook activity to make sure that the excel file is closed before deleting it.

15

if i use Kill process activity, what shall i put in the process field?

image
image1453Ă—419 19.8 KB

16

@HILOMAP

You have to specify ProcessName field as “excel” to kill Excel process.

17

thanks much:) this works!!!

1 Like
18

thanks for this as well:)

2 Likes
19

Please don’t use kill process for Excel in production environment, it may lead to issue.

I had bad experience with kill ( Excel) , so I am very careful while using kill for Excel.

Just wanted to make you little cautious.

Regards,
Ahtesham

20

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