Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Overwriting/Overlapping web query problem
I have a web query that overlaps another query. When the second we
query is added to the sheet through vba, it is suppose to overwrite th data of the first query in which it overlaps. It does in fact overwrit the data fine, however, it doesnt seem to overwrite the quer defintion. Therefore, strangely, the overlapped data contains the dat of the second query, but the query definition of the first query (whic is problematic, since I will need to refresh these queries at certai times). The code first inserts some lines, and then runs this bit to add th new query table: (both query tables run this code) With QueryTables.Add(Connection:=ConnectURL, Destination:=[B4]) .PostText = postStr .BackgroundQuery = True .PreserveFormatting = False .AdjustColumnWidth = False .RefreshStyle = xlOverwriteCells .Name = strYesterday .WebSelectionType = xlSpecifiedTables .WebTables = "4" .Refresh BackgroundQuery:=False .SaveData = True End With So, i was just wondering if i was missing something. Also, is there a way to refresh only the data, of a truncated query that remains? For example, if I delete a row from a query, can refresh the remaining query without having that row reappear on th refresh -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with pivot tables overlapping with new data | Excel Discussion (Misc queries) | |||
Odd overlapping problem with standard column chart | Charts and Charting in Excel | |||
Ms Query problem | Excel Discussion (Misc queries) | |||
Problem with MS Query - can't edit query | Excel Discussion (Misc queries) | |||
Overlapping combinations problem | Excel Programming |