Excel variable for path I would like propose a variable in an excel cell and launch a word document from other excel cell Y:\document\%variable%\proof.doc , where %variable% can take several values. The taken value is proposed in an excel cell and seen. [URL=http://img40.imageshack.us/i/screenshot1251661545.jpg/][IMG]http://img40.imageshack.us/img40/8749/screenshot1251661545.jpg[/IMG][/URL] Any similar solution is also possible for me . Thankxxx

If you would have Googled something like excel variable hyperlink you would have gotten lots of hits and methods. Bottom line is you need to use the HYPERLINK function. Look it up in Excel help to see how it works. You can do all sorts of things within the HYPERLINK function. Here's just 2 examples: - Get the file name from a cell: =HYPERLINK("file:///c:\Documents and Settings\user\My Documents\" & D1 &".xls", D1) - Get part of the path from a cell using VLOOKUP: =HYPERLINK("file:///c:\Documents and Settings\user\" & VLOOKUP(E1,C1:D10,2,0) &"\myFile.xls","Click Here")

Google is a world of possibilities via web to find without persons. Nowadays I prefer persons. I have to look for HIPERVINCULO function. Google don't knows i have a spanish version of excel 2002. And will never know. But you can. Thansk a lot Best Regards

re: Google is a world of possibilities via web to find without persons. Not true. The hits and tips regarding the HYPERLINK function were written by "persons". Many of the hits will lead you to other Excel related forums where people have submitted answers to questions almost exactly like yours. The advantage of Google, at least in this case, is that you will find many more applications of the HYPERLINK function than I have provided. re: Google don't knows i have a spanish version of excel 2002 Neither did I, until you told me, but what difference does that make? I didn't tell you about the HIPERVINCULO function, I told you about the HYPERLINK function and you translated it. Just for fun, Google hipervínculo de variable de excel and see what you get.

Yes. But I prefer the hyperlinks written by you. I try DerbyDad03 hyperlink There is a lot of interesting content. And google may be useful in this ocassion. I fin the forum with the motor google.

Ohhhhh yeahhhh. Very good Two interesting points about in computing.net Why visit the world having all in a single web ? Do you know the personalized motors ? http://www.google.com/coop/manage/cse/ I have several personalized motors. Is useful when you want visit again the places where you enjoy. In other way always goes where the information is, but don't where "the good people" is......

This is a real problem. I was trying to change my email in my settings in the forum from pming@telefonica.net to base4ingenieros@gmail.com. But I don't see how to do . Have I to sign up again ? Best Regards DerbyDad03 [img]http://img101.imageshack.us/img101/7251/besotene2.gif[/img]