P
Patrice Dargenton
I use an OWC SpreadSheet 9.0 of which I load the format via a HTML model
created from Excel. I then fill the SpreadSheet with the values of a query
in an Access form. If I copy cells one by one, the format is preserved
(except for rare case!???). I tried to fill all cells in only one
instruction via the ParseText function of SpreadSheet and the GetString
function of the ADODB RecordSet, but in this case, the format is lost
unpredictably. I tried to use a temporary SpreadSheet from which I copy the
contents without the format, but it is not faster, because I must do it cell
by cell: there is no PasteSpecial in the Range object of the SpreadSheet to
do this in only one instruction. I could save only the format of the model
from Excel, but I do not know how to avoid saving also the contents of the
cells using Excel. Does anybody have a solution?
Thanks for any assistance,
created from Excel. I then fill the SpreadSheet with the values of a query
in an Access form. If I copy cells one by one, the format is preserved
(except for rare case!???). I tried to fill all cells in only one
instruction via the ParseText function of SpreadSheet and the GetString
function of the ADODB RecordSet, but in this case, the format is lost
unpredictably. I tried to use a temporary SpreadSheet from which I copy the
contents without the format, but it is not faster, because I must do it cell
by cell: there is no PasteSpecial in the Range object of the SpreadSheet to
do this in only one instruction. I could save only the format of the model
from Excel, but I do not know how to avoid saving also the contents of the
cells using Excel. Does anybody have a solution?
Thanks for any assistance,