Error on deleting an Excel Worksheet

[HWXie]

I'm now working on the operation of EXCEL.

When I tried to open the workbook, everything goes well.
However when I used the same file path and tried to delete the worksheet, it shows "Workbook not found:.......Work book not found in instance: 1 ".

I confused how can I solve this error, please help me.
thank you so much!

[ewilson]

Hello @HWXie,
​
The screenshots are pretty small for some reason, so it's difficult to see what's going on. How are you trying to delete the workbook? The Excel VBO only has actions for deleting cells and worksheets. To delete the workbook, you'd want to use the Utility - File Management VBO.

Cheers,
Eric

[Soumya21]

Hi @HWXie

You have given full file path in workbook input parameter. I think first we should use open workbook action and then next delete worksheet action by passing workbook name which we will get from output parameter of open workbook action.

Thanks,
Soumya
​

[HWXie]

Hi, @Soumya k

thank you for replying me.
Actually, I tried to open the workbook and then delete the worksheet.
Workbook is opened successfully while there is the same error in deleting worksheet.

here is how I set the flow and action.

regards!​

[Soumya21 · Accepted solution]

Hi @HWXie

You have to give only workbook Name instead of giving entire file path in workbook input parameter ​

Thanks,
Soumya

[HWXie]

Hi, @Soumya21,

Thank you soooo much!
I solved this issue!

best regards!!


​​