Excel variable for path

Microsoft Excel 2002 (full product)
August 30, 2009 at 14:14:31
Specs: Windows XP, 3 GB
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


See More: Excel variable for path

Report •


#1
August 30, 2009 at 18:28:53
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")


Report •

#2
August 31, 2009 at 01:22:20
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


Report •

#3
August 31, 2009 at 03:59:19
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.


Report •

Related Solutions

#4
August 31, 2009 at 11:22:03
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.


Report •

#5
August 31, 2009 at 11:29:03
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......


Report •

#6
August 31, 2009 at 11:45:11
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]


Report •

#7
September 1, 2009 at 19:13:35
First, you shouldn't change subject matter within a thread. It messes up the archives.

Second, this is an Office related forum (Excel, Word, etc.) not a forum on how to use this website.

Third, you shouldn't post your email address in plain text at any site.

Finally, I don't know the answer to your question. You'll have to look elsewhere on this site to see how to change your information.


Report •


Ask Question