TKoczkodan
New Member
- Joined
- Aug 21, 2009
- Messages
- 3
Hello,
Hoping someone can help me with this. I am attempting to run a script from Excel that saves an exported report from SAP in a given location. This code runs without issue on several computers. When I emailed the code to a coworker they kept getting this error:
Run-time error '-2147024894 (80070002)':
Method 'Run' of object 'IWshShell3' failed
The code stops each time at the line in bold:
Both computers are running the same OS (Windows 7 Professional, 64 bit)
Any help would be appreciated! Thanks!
Hoping someone can help me with this. I am attempting to run a script from Excel that saves an exported report from SAP in a given location. This code runs without issue on several computers. When I emailed the code to a coworker they kept getting this error:
Run-time error '-2147024894 (80070002)':
Method 'Run' of object 'IWshShell3' failed
The code stops each time at the line in bold:
Code:
some script...
session.findById("wnd[0]/usr/ctxtSP$00008-LOW").Text = frDate
session.findById("wnd[0]/usr/ctxtSP$00008-HIGH").Text = toDate
session.findById("wnd[0]/usr/ctxtSP$00001-LOW").caretPosition = 4
session.findById("wnd[0]").sendVKey 8
Path = "C:\Users\212327875\Desktop\PlantWorkSheets\SQ00Temp.XLSX"
Set wshell = CreateObject("WScript.Shell")
[B]wshell.Run """C:\Users\212327875\Desktop\PlantWorkSheets\save_as.vbs""" & Path[/B]
Both computers are running the same OS (Windows 7 Professional, 64 bit)
Any help would be appreciated! Thanks!