Issue while opening excel due to Macro

Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-03-18 06:15 PM
Hi,
I have an excel file enabled with Macros. This Macro will run and open a form once WB got opened. We can close this form if not required. But , when i open this excel file via BP, BP not able to read the excel properly and getting time out error . Hope, because of this form( As it is opening wile open the excel) BP not able to read the excel .
Please help on this.
2 REPLIES 2

Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-03-18 10:17 AM
This is resolved by using the action 'set events enabled ' available under MS Excel VBO. Flag should be set as 'False'.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-03-18 01:07 PM
I faced the similar issue of process going into infinite loop after the create instance action from MS EXCEL VBO. Do we need to set the flag 'Enable Events' = False for the action create instance to avoid this issue? will there be any other reverse effect in changing the default value of 'Enable Event'?
