BorlandTalk.com

Guest

I'm accessing Excel from Builder 2006 C++ using the Ole functions.
Everything works well except for one thing:

The following works, using a hardcoded string for the filename:

xlWBs.OleProcedure("open","c:\\JUNK.XLS");

But if I try to use a variable, it doesn't work:
xlWBs.OleProcedure("open",sFilePath);

even when sFilePath contains the same thing as the string in the first
example (I've set a breakpoint and verified). I've tried making
sFilePath both a Variant and a String; every time it ends up with an
error. But when I hardcode the value, as above, it works fine.

Anybody have any ideas?

Thanks