Board index » cppbuilder » Using Variant in driving excel (Ole component)

2006-08-29 08:50:09 PM
cppbuilder99
Hello,
I've to use Variant in my program to drive an ole apllication (Excel)
So if i write
Variant vRange,vCell,vSheetName,vWorksheet
AnsiString sTemp; .
....
vRange="A1";
vCell=vWorksheet.OlePropertyGet("Range",vRange);
there is no problem
If I write
.....
sTemp="A1";
vRange=sTemp
vCell=vWorksheet.OlePropertyGet("Range",vRange);
I get the next error EoleSysError
Can anybody say me how to pass the right value through a local variable?
Thank your
 

"Didier" < XXXX@XXXXX.COM >wrote:
borland.public.cppbuilder.activex instead.
Alan Bellingham
--
ACCU Conference: 11-14 April 2007 - Paramount Oxford Hotel
 

Didier wrote:
AnsiString instead of a cstring.
Try
vRange=sTemp.c_str();
For a more difinitive answer, follow Alan's advice.
 

{smallsort}