Jump to content
Sign in to follow this  
Mucho

Complicated Excel Sendkey

Recommended Posts

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

Share this post


Link to post
Share on other sites
Polyphem

Ups :)...

Edited by Polyphem

This post will be edited again by Polyphem: Tomorrow, 11:55 AM

Share this post


Link to post
Share on other sites
Polyphem

How do I send the following Excel string to a cell =CONCATENATE("=Excel|[NewView.xls]Sheet3!'R",[NewView.xls]Sheet3!$H$2,"C3'")

Two problems:

  • The type of quotation marks you use to enclose the string need to be escaped by repeating them.
  • Exclamation marks need to be enclosed by braces {!} to be send as character

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

Cheers

Edited by Polyphem

This post will be edited again by Polyphem: Tomorrow, 11:55 AM

Share this post


Link to post
Share on other sites
Mucho

Poly,

Thank you. I will try it out. And very sorry for the triple posts. My pc had a communication problem.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×