StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
11949408
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-08-14T09:26:28.313
FavoriteCount
0
LastActivityDate
2017-04-10T08:06:31.297
LastEditDate
2017-04-10T08:06:31.297
LastEditorUserId
321973
OwnerUserId
388389
ParentId
11948771
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
You can catch the error level if you are that the command will return 0 on success: <a href="http://www.devx.com/vb2themax/Tip/18663" rel="nofollow noreferrer">http://www.devx.com/vb2themax/Tip/18663</a> <blockquote> <h1>Get the exit code of a process</h1> In a few cases, in particular when running MsDos batch files from within a VB application, you may want to determine the <code>ERRORLEVEL</code> set by an external application. You can't do it with a plain Shell statement, but the job becomes easy with the support of the <code>GetProcessExitCode</code> API function: <pre><code>Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Private Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As _ Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long Private Declare Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As _ Long, lpExitCode As Long) As Long Const STILL_ACTIVE = &H103 Const PROCESS_QUERY_INFORMATION = &H400 Private Sub cmdRunNotepad_Click() Dim hTask As Long Dim hProcess As Long Dim exitCode As Long hTask = Shell("Notepad", vbNormalFocus) hProcess = OpenProcess(PROCESS_QUERY_INFORMATION, False, hTask) ' loop until the process returns a valid exit code Do ' relinquish this CPU time slice Sleep 100 DoEvents ' query for exit code GetExitCodeProcess hProcess, exitCode Loop While exitCode = STILL_ACTIVE MsgBox "Exit code = " & exitCode, vbInformation End Sub </code></pre> Francesco Balena </blockquote> or you can try something like this: <pre><code>myRes = Shell("cmd /c myScript.cmd&&echo success") </code></pre> here's more info about conditional execution: <a href="http://www.robvanderwoude.com/condexec.php" rel="nofollow noreferrer">http://www.robvanderwoude.com/condexec.php</a> But in both cases you rely on exit codes.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to catch windows shell script errors launched from VBA code?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USTobias Kienzler
UserOwnerUserId
1. USnpocmaka
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.