Geting the Link path as text

Nuro

New Member
Joined
Jan 16, 2006
Messages
9
I've searched for this but can't quite seem to find the answer. I need a cell to reference part of the link in another cell.

So if A1 is linked to \\server\something\book1 - 2007-07-31.xls

I need B1 to extract the 2007-07-31 as text so that I can use it in a variable for the ChangeLink method.

Any ideas?

Thanks
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

ageren

Board Regular
Joined
Jul 30, 2007
Messages
60
try this ( i am not quite sure it is going to work or not..)

write into B1 cell; =right(A1,14)
 

Nuro

New Member
Joined
Jan 16, 2006
Messages
9
Thanks. That won't work. If the value in A1 is 612 via that link, it will still return 612. I need to return the actual path that is linked, not anything having to do with the value it is returning.

Is there anyway to grab this via VBA if you can't put the actual text into a cell?
 

Forum statistics

Threads
1,181,374
Messages
5,929,577
Members
436,680
Latest member
kellyjkon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top