Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-11-22 01:24 PM
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!


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!
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-11-22 06:40 AM
Hi @HWXie
You have to give only workbook Name instead of giving entire file path in workbook input parameter
Thanks,
Soumya
You have to give only workbook Name instead of giving entire file path in workbook input parameter
Thanks,
Soumya
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-11-22 02:34 PM
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
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-11-22 04:16 PM
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
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-11-22 06:29 AM
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!
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!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-11-22 06:40 AM
Hi @HWXie
You have to give only workbook Name instead of giving entire file path in workbook input parameter
Thanks,
Soumya
You have to give only workbook Name instead of giving entire file path in workbook input parameter
Thanks,
Soumya
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-11-22 06:47 AM
Hi, @Soumya21,
Thank you soooo much!
I solved this issue!
best regards!!
Thank you soooo much!
I solved this issue!
best regards!!
