Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
web query format
I am using the web query:
With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://webpage.com?" & courseCode _ , Destination:=Range("A9")) And this picks up a 4 row by 5 column table. The problem is that when it pastes this into the range A9 it inserts 5 colums there. I don't want it to insert columns but rather just to paste into the cells that are already there. Does anyone know the code for this? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query and date format | Excel Discussion (Misc queries) | |||
Maintaining Cell Format in Query | Excel Discussion (Misc queries) | |||
Conditional Format Rank query | Excel Discussion (Misc queries) | |||
MS Query Date Format | Excel Discussion (Misc queries) | |||
Query Data Format | Excel Discussion (Misc queries) |