I have created a number of Excel workbooks with VBA with the help of EE.
Sometimes, when multiple workbooks are opened, VBA that normally runs without a hitch, fails.
I have to close down all instances of Excel, clear the user temp files and then reopen.
Is there a better solution? eg. Use VBA to clear temp files