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

[rudi]

How do I send the following Excel string to a cell

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

Without having tested anything, if special chars are giving trouble you might want to try the clipboard:

$SaveAway=ClipGet()
$MyString='CONCATENATE("=Excel|[NewView.xls]Sheet3!'R",[NewView.xls]Sheet3!$H$2,"C3'")'
clipput($mystring)
send("^v")
ClipPut($SaveAway)