Run Batch script in background | Jenkins in background | Excel VBA Tips & Tricks

[@paulrankine680]

Thank you, I have been surfing the net trying to get something to get this bit to work in outlook and your video was absolute genius . Worked perfectly for someone who knows absolutely nothing about macro's and it was good insight regarding the window style argument. Thanks

[@seemoonhabeeb1478]

Hello.. Is there a way to execute the command through vba excel without writing the command in bat file I mean executing the command without putting path of the attached file... Thank you

[@xtremeExcel]

yes you can do. Call Shell("cmd.exe /c cd C:\Users\Kamal\Downloads\" & " && mkdir newfolder" & " && java -jar jenkins.war") This will open command prompt, change directory, create a folder and execute a command.

[@yashmanavadariya]

Do you have any idea how to run application in foreground using Jenkins??

[@cu806]

What is this batch gikr and what can it be used to do and can it be done with none bat files

[@shiguehashimoto1247]

Hi Kamal, how can I hide Command prompt Window during the execution of this procedure? Sub ExecPing() Dim strShellCommand As String Dim strCompAddress As String Dim objSh As Object Dim objEx As Object Dim result As String On Error GoTo ErrorPing strCompAddress = InputBox("Informe o IP!") If strCompAddress = "" Then Exit Sub Else End If strShellCommand = "C:\Windows\System32\PING.exe " + strCompAddress Set objSh = CreateObject("WScript.Shell") Set objEx = objSh.Exec(strShellCommand) result = objEx.StdOut.ReadAll MsgBox "Resultados Ping para o IP:" & strCompAddress & vbCrLf & result Exit Sub ErrorPing: MsgBox "Erro no procedimento Ping!" End Sub

[@riyazshaikh6031]

Actually I have on excel file where I have implemented Button from Developer tab. My batch file opening the Excel file but I am not able to click the Button which is used for sending automatic email from excel. Can u tell me how to write batch file which will click this button? Thanks

[@andrefmartin]

Hi. How do you run a command like ' ssh username@ip "aLinuxScriptOrCommand" ' and capture its output inside the Excel/VBA ?

[@buijenny7060]

It's not run in excel 365. How to fix this error? Thanks

[@seemoonhabeeb1478]

Hello..Thank you for the answer..but I have a second question. How can I display an image in Windows Viewer.., that is, independently of Excel..thank you🙏

[@WoLFyy2009]

i have downloaded ngrok.exe for cmd windows 7 i put it ont c:/windows to execute it in cmd i wrote a bat file in it @echo off start ngrok and i created a vbs file to make it invisible it still dont work except if i let it showing the black screen of ngrok tcp etc any solution? :D