This May Be Complicated

[Swat]

Two questions:-

1. Is it possible to extract the filename from a formula and if so how? I have a formula which is linked to another workbook and need to show the workbook name in another cell.

2. Or alternatively can the formula be shown as text in another cell?

Thanks in advance.

 

[Willem!]

Hi,

What are you trying to accomplish?

A solution for 2) can be found here:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=62

HTH

 

[Swat]

Thankyou, that's solved that problem.

 

[Willem!]

Glad I could assist!