Workbook links from a cell within another workbook

[SCBMCQUAY]

Hello All!

Awesome forum!

I am trying to create a tool to help with some calculations we do all the time. Every time we design a new product, we need to do several calculations I have a workbook with 40 tabs with calculations on them that result in data, let's call this Wkbk A. I have another workbook that I need to use that data to do more calculations and create more data let's call this Wkbk B. Combining the 2 workbooks makes it too large and cumbersome.

What I would like to do is this.

After the user has entered the data into Wkbk A have them open Wkbk B. When they open Wkbk B there would be a box that pops up and has them browse for or enter the name and path for Wkbk A (because they will change the name for every job) Then Wkbk B would use the data from Wkbk A to do the calculations. As well, it would be cool if somewhere in Wkbk B you could see the path and filename of the Wkbk A it was referencing and you could change it if you desired. Also it would be better if the popup box prompting the path for Wkbk A didn't popup if a file was already linked.

Tall order??

Any help for this neophyte would be appreciated.

Thanks

Steve

[6StringJazzer]

This requires VBA. Attached is a simple workbook that, when you open it, prompts you for a file then puts the path in B1. It doesn't open the file, just gets the name.

You will have to allow macros to run for this to work.

As far as what you do with the file name once you have it, that's a whole nother issue. If you use the INDIRECT function you will find that the referenced file has to be open or the formula will return a #REF! error.

I don't understand what you mean by this:

Also it would be better if the popup box prompting the path for Wkbk A didn't popup if a file was already linked.