Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with VBA web query
Hello
I'm trying to build a database searching information in the web through web queries but I really cannot get a good result using VBA. The code is the following: Sub ImportComments() Dim QT As QueryTable ConnectString = "URL;http://groups.google.com/group/ microsoft.public.excel.programming/browse_frm/month/2007-07" Set QT = ActiveSheet.QueryTables.Add(Connection:=ConnectStr ing, _ Destination:=Range("A1")) With QT .WebSelectionType = xlAllTables .WebFormatting = xlWebFormattingNone .BackgroundQuery = False .AdjustColumnWidth = True .EnableRefresh = True .RefreshStyle = xlOverwriteCells .Refresh End With End Sub If I proceed manually I can get any table. Is there any way to make it with VBA? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Web Query | Excel Programming | |||
Web query VBA problem | Excel Programming | |||
Query Problem | Excel Worksheet Functions | |||
Problem with MS Query - can't edit query | Excel Discussion (Misc queries) | |||
Problem with .Background Query option of ODBC Query | Excel Programming |