re: Shell run-time error 5, invalid procedure call or argument
I hope my postings are usefull for one or another.
For completeness:
Our Trend Micro Virus Scanner has been auto updated (in August 2009, Version 08/07/2009, 08/05/2009) and now those Shell()-errors are gone, even with activated virus scanner.
User Profile
Collapse
-
Solved (at least _my_ issue)
Good news!
After a few days of research in this this VBA Shell() run-time error 5, we figured our virus scanner out to be the culprit. We deactivated the Trend Micro Virus Scanner at our workstations and all my tested methods for executing a file from VBA worked well again.
I wonder why it took us so long to blame the virus scanner and test it...
I hope at least this...Leave a comment:
-
VBA Shell run-time error 5 invalid procedurecall or agument
Hi at all!
I've got the same VBA Shell() problem, too.
Calling Shell() from VBA MS Office 2007 on WinXP SP3 and from VBA MS Office 2003 on another WinXP SP3 Computer doesn't work and seems to be broken. (VBA run-time error 5)
The same Office document produces the same error on other WinXP SP3 machines, but works correctly on SP2 computers (tested...Leave a comment:
No activity results to display
Show More
Leave a comment: