Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell command in VBA suddenly stops working
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell command in VBA suddenly stops working
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 In article , says... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell command in VBA suddenly stops working
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! |
#4
|
|||
|
|||
Please has any one found a solution to this problem I am having a similar issue.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation in XL2007 suddenly stops functioning | Excel Discussion (Misc queries) | |||
Shell command | Excel Programming | |||
Shell command stopped working: is it part of Excel 95 , or Windows? | Excel Programming | |||
xp shell command using vba | Excel Programming | |||
WindowStyle not working in shell command | Excel Programming |