Shell command in VBA suddenly stops working

  • Thread starter Thread starter Ian Parker
  • Start date Start date
I

Ian Parker

I have called an external process for many years using the Shell
command in VBA.

Suddenly yesterday it stopped working. I get a

Run Time error '5'
Invalid procedure call or argument.

On debug the return value is empty.
I use the fully qualified name for the external exe file.

Please I am at a loss. I have tried various help systems and got
nowhere. Is it a permissions thing?

Ian
 
This is a shot in the dark, but did you recently install Windows XP
SP2? Or some other Office related update? Perhaps, it tightens
security around the VB(A) use of Shell...

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
I have recently added SP3 for office. However this did not cure the
fault. The situation before and after are the same. I also uninstalled
and reinstalled Office and this did no good either.
 
Back
Top