topic Re: Error on deleting an Excel Worksheet in University Forum

Error on deleting an Excel Worksheet

HWXie — Mon, 28 Nov 2022 13:24:09 GMT

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!

Re: Error on deleting an Excel Worksheet

ewilson — Mon, 28 Nov 2022 14:34:34 GMT

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

Re: Error on deleting an Excel Worksheet

Soumya21 — Mon, 28 Nov 2022 16:16:17 GMT

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

Re: Error on deleting an Excel Worksheet

HWXie — Tue, 29 Nov 2022 06:29:52 GMT

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!

Re: Error on deleting an Excel Worksheet

Soumya21 — Tue, 29 Nov 2022 06:40:14 GMT

Hi @HWXie

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

Thanks,
Soumya

Re: Error on deleting an Excel Worksheet

HWXie — Tue, 29 Nov 2022 06:47:03 GMT

Hi, @Soumya21,

Thank you soooo much!
I solved this issue!

best regards!!