Click here to Skip to main content
16,017,297 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Graphic in DataGridView problem Pin
Mangore756-Feb-12 6:24
Mangore756-Feb-12 6:24 
GeneralRe: Graphic in DataGridView problem Pin
Richard MacCutchan6-Feb-12 6:33
mveRichard MacCutchan6-Feb-12 6:33 
GeneralRe: Graphic in DataGridView problem Pin
Mangore756-Feb-12 8:26
Mangore756-Feb-12 8:26 
GeneralRe: Graphic in DataGridView problem Pin
Richard MacCutchan6-Feb-12 9:30
mveRichard MacCutchan6-Feb-12 9:30 
AnswerRe: Graphic in DataGridView problem Pin
Luc Pattyn6-Feb-12 0:23
sitebuilderLuc Pattyn6-Feb-12 0:23 
GeneralRe: Graphic in DataGridView problem Pin
Mangore756-Feb-12 6:22
Mangore756-Feb-12 6:22 
AnswerRe: Graphic in DataGridView problem Pin
Luc Pattyn6-Feb-12 6:33
sitebuilderLuc Pattyn6-Feb-12 6:33 
QuestionGetting a table Pin
Dalek Dave5-Feb-12 8:50
professionalDalek Dave5-Feb-12 8:50 
In VBA for excel I can lift a table from a website using the QueryTables.Add method.

Here is what I use within an existing excel page...

VB
With ActiveSheet.QueryTables.Add(Connection:= _
    "URL;http://www.Website.com/Subdir", Destination:=Range("$A$1"))
    .Name = "TableName"
    .FieldNames = True
    .RowNumbers = False
    .FillAdjacentFormulas = False
    .PreserveFormatting = True
    .RefreshOnFileOpen = False
    .BackgroundQuery = True
    .RefreshStyle = xlInsertDeleteCells
    .SavePassword = False
    .SaveData = True
    .AdjustColumnWidth = True
    .RefreshPeriod = 0
    .WebSelectionType = xlAllTables
    .WebFormatting = xlWebFormattingNone
    .WebPreFormattedTextToColumns = True
    .WebConsecutiveDelimitersAsOne = True
    .WebSingleBlockTextImport = False
    .WebDisableDateRecognition = False
    .WebDisableRedirections = False
    .Refresh BackgroundQuery:=False
End With

As you can see, this polls the website and then looks for the table on that website that I need to connect to.

However, I would like to do the same thing within a VB.Net application.
What method would I need, and are there any pointers you good people could help me out with?
------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

CCC Link[^]
Trolls[^]

AnswerRe: Getting a table Pin
ChandraRam5-Feb-12 22:07
ChandraRam5-Feb-12 22:07 
GeneralRe: Getting a table Pin
Dalek Dave6-Feb-12 1:49
professionalDalek Dave6-Feb-12 1:49 
QuestionCrystal report problem Pin
Pasan1485-Feb-12 4:25
Pasan1485-Feb-12 4:25 
AnswerRe: Crystal report problem Pin
Dave Kreskowiak5-Feb-12 7:38
mveDave Kreskowiak5-Feb-12 7:38 
QuestionCreate Pdf Viewer disable SaveAs option Pin
Arul Suman4-Feb-12 23:28
Arul Suman4-Feb-12 23:28 
AnswerRe: Create Pdf Viewer disable SaveAs option Pin
Abhinav S4-Feb-12 23:40
Abhinav S4-Feb-12 23:40 
GeneralRe: Create Pdf Viewer disable SaveAs option Pin
Arul Suman4-Feb-12 23:47
Arul Suman4-Feb-12 23:47 
GeneralRe: Create Pdf Viewer disable SaveAs option Pin
Abhinav S4-Feb-12 23:54
Abhinav S4-Feb-12 23:54 
GeneralRe: Create Pdf Viewer disable SaveAs option Pin
Eddy Vluggen5-Feb-12 0:17
professionalEddy Vluggen5-Feb-12 0:17 
QuestionCreate Pdf Viewer Pin
Arul Suman4-Feb-12 23:22
Arul Suman4-Feb-12 23:22 
AnswerRe: Create Pdf Viewer Pin
Abhinav S4-Feb-12 23:42
Abhinav S4-Feb-12 23:42 
GeneralRe: Create Pdf Viewer Pin
Arul Suman4-Feb-12 23:52
Arul Suman4-Feb-12 23:52 
GeneralRe: Create Pdf Viewer Pin
Eddy Vluggen5-Feb-12 0:18
professionalEddy Vluggen5-Feb-12 0:18 
GeneralRe: Create Pdf Viewer Pin
Arul Suman5-Feb-12 0:51
Arul Suman5-Feb-12 0:51 
GeneralRe: Create Pdf Viewer Pin
Eddy Vluggen5-Feb-12 0:56
professionalEddy Vluggen5-Feb-12 0:56 
QuestionNewby to ADO.NET needs help upgrading from VB6 recordset update batch Pin
Member 86051774-Feb-12 5:51
Member 86051774-Feb-12 5:51 
AnswerRe: Newby to ADO.NET needs help upgrading from VB6 recordset update batch Pin
Eddy Vluggen5-Feb-12 6:05
professionalEddy Vluggen5-Feb-12 6:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.