Wow.. For the immediate awesome replies...
2. I'm not sure which specific prompt you refer to, but VBA related ones unfortunately can't be automatically clicked away (at least in a structured manner). On the built-in ones I would need to test, but if they show up than I think I can solve that easily.
Reply: Just reference a table data from another workbook into this workbook and save it in such a way that the formula will update on opening this workbook. Now, rename or move the source workbook (the referenced one), so while opening this workbook, it will prompt whether the reference needs to be updated... These kind of prompts I am saying.
3. This is something I would need to test as well, however, generally if the app caught an error then it should be visible from the main UI (yeah I could see that error has occurred, but if there is an option to catch that error and act accordingly would be great - don't know whether this feature is already available). If not, then it would hang until the timeout period. I'll double check that for be sure.
Reply: If you want to test this, create a query which fetches column a, b, c from a table and save the file. Now, rename/remove one of the columns and try to refresh the Excel, it will throw an error. But this automation automatically accepts the prompt.
2. I'm not sure which specific prompt you refer to, but VBA related ones unfortunately can't be automatically clicked away (at least in a structured manner). On the built-in ones I would need to test, but if they show up than I think I can solve that easily.
Reply: Just reference a table data from another workbook into this workbook and save it in such a way that the formula will update on opening this workbook. Now, rename or move the source workbook (the referenced one), so while opening this workbook, it will prompt whether the reference needs to be updated... These kind of prompts I am saying.
3. This is something I would need to test as well, however, generally if the app caught an error then it should be visible from the main UI (yeah I could see that error has occurred, but if there is an option to catch that error and act accordingly would be great - don't know whether this feature is already available). If not, then it would hang until the timeout period. I'll double check that for be sure.
Reply: If you want to test this, create a query which fetches column a, b, c from a table and save the file. Now, rename/remove one of the columns and try to refresh the Excel, it will throw an error. But this automation automatically accepts the prompt.