Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 57
  • 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
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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