WScript.Shell Not Working Under Excel 2013

[yossicadaner]

B"H

Good morning,

I have been using the WScript.Shell object in order to execute java applications with sending parameters (various strings). Example:

Please Login or Register  to view this content.

As the office I work in has updated to Excel 2013, I learned that this object is not working. Generates Run-time error '-2147024894 (80070002) The system cannot find the file specified.

Does anyone have a clue as how this problem can be fixed or worked around?

Thank you very much - in advance

[Kenneth Hobson]

Welcome to the forum!

I would use Dir(filepath/filename)<>"" first to see if the file exists before using it like that.

Otherwise, I suspect it is the Microsoft Scripting Runtime object issue. http://colinlegg.wordpress.com/2012/...untime-errors/

[yossicadaner]

Thanks for your reply. I tried following the article you quoted, but it bore no success with the issue.
I resolved it eventually. I tried running the same VBA code under a different user account, and it ran perfectly. So I deleted all of Excel's user information from both the registry and the appdata folder. When I started Excel it ran the installation configuration wizard, and it worked great.

Kind regards