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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
web query format
Here are a couple of ideas you can modify to suit your needs.
'at the start Sheets("Data").Rows("2:300").Delete ===== 'at the end For Each Name In Sheets("Data").Names Name.Delete Next Name ======== "Bill C" wrote in message m... 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. |
Reply |
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) |