Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 44
  • Last Modified:

Reg: How to use batch script output value in vbscript

Hi All,

i have Below Batch script command

@echo off
set VAR=%errorlevel%
D:\SchedTasks\IFRS-Transfer\psftp.exe IFRS@DM3CXJ -pw XXXX -b IFRSTransfer.txt
echo %VAR%
exit /b %ERRORLEVEL%

And i wanted to use VAR value of this batch script in VBscript.

so kindly please tell me how can i use .

Thanks,
Abhishek
0
Abhishek kumar
Asked:
Abhishek kumar
  • 3
  • 2
  • 2
  • +2
1 Solution
 
xtermieCommented:
Use the WScript.Shell object's Environment property.
Example (gets the NUMBER_OF_PROCESSORS variable, this is taken from
Windows Script Host documentation):

Set WshShell = WScript.CreateObject("WScript.Shell") 
Set WshSysEnv = WshShell.Environment("SYSTEM") 
WScript.Echo WshSysEnv("NUMBER_OF_PROCESSORS") 

Open in new window


Refer to
https://msdn.microsoft.com/en-us/library/at5ydy31(v=vs.84).aspx
https://msdn.microsoft.com/en-us/library/6s7w15a0(v=vs.84).aspx
0
 
QlemoC++ DeveloperCommented:
Why? VAR contains the error level at batch start, which is 0. This doesn''t have any "value". The exit code is important, and that is what you automatically get from the Shell.Run method calling the batch file.
0
 
oBdACommented:
You're aware that %VAR% contains the errorlevel before the psftp.exe call?
Anyway, assuming you want to call the VBScript from this batch (or are you calling the batch from VBScript? that would be rather cumbersome, because you might just as well run the psftp.exe directly from VBScript), you just pass it as command line argument:
VBS:
VAR = WScript.Arguments(0)
Wscript.Echo "VAR is " & VAR

Open in new window

Batch:
@echo off
set VAR=%errorlevel%
D:\SchedTasks\IFRS-Transfer\psftp.exe IFRS@DM3CXJ -pw XXXX -b IFRSTransfer.txt
echo %VAR%
cscript.exe //nologo "C:\Temp\Whatever.vbs" %VAR%
exit /b %ERRORLEVEL%

Open in new window

1
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Abhishek kumarAuthor Commented:
Hi,
Actually i wanted to use the psftp.exe exit code value in vb script for sending the mail whether file transfer is successful or Failed.

Here i am calling Batch script command inside VB Script.

So please help me how can i do this .

Thanks,
Abhishek
0
 
oBdACommented:
Batch:
@echo off
D:\SchedTasks\IFRS-Transfer\psftp.exe IFRS@DM3CXJ -pw XXXX -b IFRSTransfer.txt
exit /b %ERRORLEVEL%

Open in new window

VBS:
Set objShell = CreateObject("WScript.Shell")
intReturn = objShell.Run(Chr(34) & "D:\Temp\Whatever.cmd" & Chr(34), 0, True)

Open in new window


Or just call psftp.exe directly from VBS:
strFtpProgram = "D:\SchedTasks\IFRS-Transfer\psftp.exe"
strFtpUser = "IFRS@DM3CXJ"
strFtpPassword = "XXXX"
strFtpFile = "IFRSTransfer.txt"

Set objShell = CreateObject("WScript.Shell")
strCommand = Chr(34) & strFtpProgram & Chr(34) & " " & strFtpUser & " -pw " & Chr(34) & strFtpPassword & Chr(34) & " -b " & Chr(34) & strFtpFile & Chr(34)
intReturn = objShell.Run(strCommand, 0, True)

Open in new window

Run Method (Windows Script Host)
https://msdn.microsoft.com/en-us/library/d5fk67ky.aspx
1
 
Abhishek kumarAuthor Commented:
Thank you so much :)

its working as expected :)
0
 
Abhishek kumarCommented:
Hi oBdA,

For below Script

@echo off
pscp.exe -i seom.ppk D:\Informatica\9.6.1\server\infa_shared\TgtFiles\IFRS\Customer\zrrem19cus* seom@sapcir-qa.intranet.z.ca:/infiles
exit /b %ERRORLEVEL%

its not returning the Exitcode value and also the batch command is running for longer time

so kindly please help me how can i use exit code value of this batch script in VBscript.

Thanks,
Abhishek
0
 
oBdACommented:
That's not an issue with the batch file itself.
If this batch runs a long time, then it's the pscp.exe command that's taking long; the batch script will just wait until it's done.
Once pscp.exe is done, the errorlevel returned by it will be passed to the calling program just like with psftp.exe (that is, if pscp.exe returns an errorlevel to begin with - not all programs do).
1
 
Abhishek kumarCommented:
Okay Sir.

Thank you so much :)
0
 
xtermieCommented:
Solution provided
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now