Sign in to follow this  
Followers 0
Mucho

Complicated Excel Sendkey

5 posts in this topic

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

#2 ·  Posted (edited)

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

#3 ·  Posted (edited)

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

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  
Followers 0