StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16236408
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-04-26T12:24:40.877
FavoriteCount
0
LastActivityDate
2013-04-26T12:24:40.877
LastEditDate
LastEditorUserId
0
OwnerUserId
0
ParentId
16072517
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
No luck here, site writes "Connecting..." eternally. But to sort out your issue, here's a sample code:<pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim myIE As InternetExplorer, myDoc As HTMLDocument, mySubDoc As HTMLDivElement Dim sVal As String, lVal As Long <pre><code>Set myIE = New InternetExplorer With myIE .Visible = True Call .navigate("http://stackoverflow.com/") While Not .readyState = READYSTATE_COMPLETE DoEvents Wend Set myDoc = .document End With 'SAMPLE With mySubDoc Set mySubDoc = myDoc.getElementsByClassName("question-summary narrow").Item(0) sVal = CStr(mySubDoc.ID) lVal = CLng(mySubDoc.NodeType) Call MsgBox(sVal) Call MsgBox(CStr(lVal)) End With On Error Resume Next Call mySubDoc.Close Call myDoc.Close Call myIE.stop Call myIE.Quit On Error GoTo 0 Set mySubDoc = Nothing Set myDoc = Nothing Set myIE = Nothing </code></pre> End Sub</code></pre>Please note: In Excel's VBA (ALT+F11) you have to add Reference (Tools->References) to <code>Microsoft HTML Object Library</code> and <code>Microsoft Internet Controls</code> items. You can use the above guy to pick up values from the page source of the loaded page on your target site. So you have to set values you want, press the "Estimate" button, 'View Page Source' and look for the values' container node which you want to extract from VBA code (and add to your Excel VBA of course). With having your site down -ie inaccessible result page- that's all I can do but with the above code you can figure out the rest of what you have to do in Excel VBA for sure. If not, post a new question or ask here when site is up again. Hope this helps!
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PORead Data From Web Form to Excel using VBA?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. This table or related slice is empty.
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
 VTDownMod
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.