I would like to know how to ignore warning/error popups while running Powershell for Excel com objects. However I'd still like the errors to be logged in the Powershell console (as it is with my current code below).
One error for example is that the import file excel is trying to retrieve does not exist, in which case I have to press OK.
The exact error message is:
"The internet address *internet address* is not valid"
and there's an "OK" button to press and continue.