I have an Excel worksheet that extracts live data from the web to a column
at regular time intervals set by the user and is continuously updated.
I could transfer this data to another workbook/worksheet by creating a
macro and producing a graph wherby time could be reproduced along the
horizontal axis and the other data reproduced on the vertical axis?
I think I would have to create a timer function within the VB code, so the
data could be copied/pasted at a set intervals; or is there a simpler way?
I think each set fresh data would require pasting into a new column in a
new workbook/worksheet in order to create a graph simply?
There must be some coding that I could adapt from finacial worksheet
somewhere?
Sorry if I am not explicit enough, as I only have a basic knowledge of VB6.
at regular time intervals set by the user and is continuously updated.
I could transfer this data to another workbook/worksheet by creating a
macro and producing a graph wherby time could be reproduced along the
horizontal axis and the other data reproduced on the vertical axis?
I think I would have to create a timer function within the VB code, so the
data could be copied/pasted at a set intervals; or is there a simpler way?
I think each set fresh data would require pasting into a new column in a
new workbook/worksheet in order to create a graph simply?
There must be some coding that I could adapt from finacial worksheet
somewhere?
Sorry if I am not explicit enough, as I only have a basic knowledge of VB6.