Alert messages during excel workbook prevents the VBO Excel to perform "Get" functionalities

rikrelop

New Member
Hello again!

Now I'm trying to open a standardized Excel workbook (which I can't perform any kind of editing on it) to use "Get Cell Value" from BP native VBO Excel. The problem is that after creating the needed instance and opening the workbook, BP gets stuck on alert messages from the workbook itself. These are specific alert messages which I have to manually press "Ok" for the workbook to be fully loaded. This way, only after pressing "Ok" manually, BP is advancing through the next stages.

Have any of you ever experienced this? If so, what was your solution?

Remember, I can't change the file. I'll have to work BP in this circumstance.

I appreciate your help in advance.

Kind regards,
 

anisjolly

Administrator
@rikrelop I've only experienced this when there are linked dependencies within the Workbook. If it isn't a message asking you to Enable Macros then you're going to have to develop a custom object to handle that dialog box.

If it is the Enable Macros message then you can Enable Events from within the Excel VBO
 
Top