Mucho Posted September 11, 2008 Share Posted September 11, 2008 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 Link to comment Share on other sites More sharing options...
Polyphem Posted September 11, 2008 Share Posted September 11, 2008 (edited) Ups ... Edited September 11, 2008 by Polyphem This post will be edited again by Polyphem: Tomorrow, 11:55 AM Link to comment Share on other sites More sharing options...
Polyphem Posted September 11, 2008 Share Posted September 11, 2008 (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 September 11, 2008 by Polyphem This post will be edited again by Polyphem: Tomorrow, 11:55 AM Link to comment Share on other sites More sharing options...
Mucho Posted September 11, 2008 Author Share Posted September 11, 2008 Poly, Thank you. I will try it out. And very sorry for the triple posts. My pc had a communication problem. Link to comment Share on other sites More sharing options...
PsaltyDS Posted September 11, 2008 Share Posted September 11, 2008 Please tell me you didn't TRIPLE POST this! Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now