Shell command in VBA suddenly stops working

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
 
T

Tushar Mehta

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

Ian Parker

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.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top