View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Excel variable for path

That requires coding. Not sure if you know how to do that in Excel or not...

the resulting open would be "Y:\document\"&Range("A2")&"\proof.doc"

"Esgrimidor" wrote:


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.

'[image:
http://img40.imageshack.us/img40/8749/screenshot1251661545.jpg]'
(http://img40.imageshack.us/i/screenshot1251661545.jpg/)


Any similar solution is also possible for me .

Thankxxx




--
Esgrimidor