topic Re: Working with Excel Binary Workbook : MS Excel VBO in Product Forum

Working with Excel Binary Workbook : MS Excel VBO

harshithaakumar — Wed, 22 Sep 2021 13:13:57 GMT

Hello everyone,

I am currently accessing a MS Excel Binary Workbook (.xlsb) using the MS Excel VBO.
(Steps : Create Instance, Open Workbook, Set Cell Value, Save Workbook, Close instance)

While saving the Binary workbook after writing data into it, I am getting the following pop-up with the following message :
Microsoft Visual Basic (Window Title)
Run Time Error 13 (Message)
Type mismatch

The workbook gets saved once I close the pop-up (Click "End")

I have tried converting the .xlsb file into .xlsx file. However I face the same pop-up then as well.

Has anyone faced this issue before and what was the work around used?

Thanks for the help!

Re: Working with Excel Binary Workbook : MS Excel VBO

VedSengupta — Wed, 22 Sep 2021 13:43:06 GMT

Hello Harshitha,
You can create a new object to attach to this popup and close using mouse clicks.

Re: Working with Excel Binary Workbook : MS Excel VBO

EVIPUTI — Sun, 26 Sep 2021 10:42:15 GMT

Use any one from the below options :
1- Create an object and use Application Modeller to click yes to ensure that the Excel works normally.
2- use the global keys
3- add this line in you code stage to where it is failing ""instance.DisplayAlerts = false"" .

Re: Working with Excel Binary Workbook : MS Excel VBO

krishna.kodimurali9 — Mon, 04 Oct 2021 15:08:01 GMT

Hi Harshita,

As I can see from your screenshot, it seems there is a module present in the Visual basic section of excel which is with errors.
Try to identify if that module is of any use, if not then delete the VB module so that you won't get that pop again.