|
#1
|
|||
|
|||
![]() I am trying to use this code to update my workbook, problem i have is when it updates it moves cells can some one add whats needed so the data is overwriten and no new cells added.
Code:
Last edited by Shaun : 27th May 2009 at 03:55 PM. |
#2
|
|||
|
|||
![]() I have made some changes to the way i want to import webpages but need some help.
Below is the code i will use to import a web query but what i need to do is link it to a cell that will use a vlookup formula what i intend to do is in column A i will have a list of races in column B i will have a weblink to the races then in cell C1 i will have the vlookup formula i need the macro to run and return the contenst of the webpage in excel. I have looked at a few examples but and still not getting the result i need Code:
|
#3
|
|||
|
|||
![]() Ok i have worked out how to link it to a cell now i am trying to get it to work on a calculation event so it will run automatic.
Code:
|
#4
|
|||
|
|||
![]() Problem solved
|
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|