I use linked spread sheets in Excel with visual basic script. The problem is that if excel is cannot link to the other program it gives me a prompt to open it. But if the program does not exist on the system it will never stop asking and that means that I cannot asses this spread sheet or any of my spreadsheets. So I have to kill excel and loose any unsaved information from my other spreadsheets.
Another problem is if a spread sheet has a visual basic script error from me entering a bad or invalid entry or something else. The error prompt once again cannot be closed so I once again have to kill excel and loose unsaved data.
Is there any way to configure excel how many times the same error can appear so I am not stuck in a loop. And if not, is there any way to save all files even if I cannot get any excel focus?
Thanks
Another problem is if a spread sheet has a visual basic script error from me entering a bad or invalid entry or something else. The error prompt once again cannot be closed so I once again have to kill excel and loose unsaved data.
Is there any way to configure excel how many times the same error can appear so I am not stuck in a loop. And if not, is there any way to save all files even if I cannot get any excel focus?
Thanks
Facebook
Twitter