Hello All!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
<o></o>
Awesome forum!<o></o>
<o></o>
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. <o></o>
<o></o>
What I would like to do is this.<o></o>
<o></o>
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.<o></o>
<o></o>
Tall order??<o></o>
<o></o>
Any help for this neophyte would be appreciated.<o></o>
<o></o>
Thanks<o></o>
<o></o>
Steve<o></o>
fficeffice" /><o></o><o
></o>Awesome forum!<o
></o><o
></o>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. <o
></o><o
></o>What I would like to do is this.<o
></o><o
></o>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.<o
></o><o
></o>Tall order??<o
></o><o
></o>Any help for this neophyte would be appreciated.<o
></o><o
></o>Thanks<o
></o><o
></o>Steve<o
></o>
