Complicated Excel Sendkey

[Mucho]

How do I send the following Excel string to a cell

=CONCATENATE("=Excel|[NewView.xls]Sheet3!'R",[NewView.xls]Sheet3!$H$2,"C3'")

I appreciate any help.

Thanks,

Thomas

[PsaltyDS]

How do I send the following Excel string to a cell

=CONCATENATE("=Excel|[NewView.xls]Sheet3!'R",[NewView.xls]Sheet3!$H$2,"C3'")

I appreciate any help.

Thanks,

Thomas

Perhaps:

$sFormula = '=CONCATENATE("=Excel|[NewView.xls]Sheet3!''R",[NewView.xls]Sheet3!$H$2,"C3''")'
_ExcelWriteFormula($oExcel, $sFormula, "B10")

Note the doubled-up single quotes inside the string to preserve the literal single quotes.

>_<

P.S. And don't double post...

Edited September 11, 2008 by PsaltyDS