T
tmarko
I would like to produce a recordset on my server (VB6)
then in Excel produce a range of data. (client-server
application) (RS is the usual way in this application to
transfer data between Client and server especially for
large data contents like this) but maybe I need to
reconsider. Currently Excel 97 but sson Excel 2003 (XML
can be used)
The range should be dynamic and will consist of a fix Y
axix of 365 days and a dynamic X axix of different
companies and their shareprices for these days producing
columns of shareprices for these days for different
companies. The top row should have the name of the
company.
How should the recorset look like to be as fast as
possible when producing this range of data and how does
the code (VBA) code in Excel when producing the range of
data from the recordset?
then in Excel produce a range of data. (client-server
application) (RS is the usual way in this application to
transfer data between Client and server especially for
large data contents like this) but maybe I need to
reconsider. Currently Excel 97 but sson Excel 2003 (XML
can be used)
The range should be dynamic and will consist of a fix Y
axix of 365 days and a dynamic X axix of different
companies and their shareprices for these days producing
columns of shareprices for these days for different
companies. The top row should have the name of the
company.
How should the recorset look like to be as fast as
possible when producing this range of data and how does
the code (VBA) code in Excel when producing the range of
data from the recordset?