Y
yurik
Hello,
In my project I am calling MFC dll using VBA in order to run query against
external data source and render the returning result set _Arr As VARIANT in
Excel. For rendering it on the worksheet, the following is used:
Set rng = wsActive.Cells(1, 1).Resize(lNumRows, lNumCols)
rng = TransposeDim(_Arr),
where function TransposeDim(v As Variant) As Variant transposes dimensions.
The each cell value could be any type Variant can handle. It could be also
basic string up to 4K in size.
In that particular case with large text value, the statement Range = Array
works fine in Excel 2000, but failes in Excel XP with error code 1004, error
description "Application-defined or object-defined error", which may
correspond
to "Methodname method of classname class failed"
Please advise
Thanks,
Yuri
In my project I am calling MFC dll using VBA in order to run query against
external data source and render the returning result set _Arr As VARIANT in
Excel. For rendering it on the worksheet, the following is used:
Set rng = wsActive.Cells(1, 1).Resize(lNumRows, lNumCols)
rng = TransposeDim(_Arr),
where function TransposeDim(v As Variant) As Variant transposes dimensions.
The each cell value could be any type Variant can handle. It could be also
basic string up to 4K in size.
In that particular case with large text value, the statement Range = Array
works fine in Excel 2000, but failes in Excel XP with error code 1004, error
description "Application-defined or object-defined error", which may
correspond
to "Methodname method of classname class failed"
Please advise
Thanks,
Yuri