Linking seperate workbooks

Rick M · May 20th, 2002, 09:42 AM

I have 2 workbooks linked together. Can the formula in book2 (be dynamic) to reflect the path the user saves book1 to?

example existing formula: =IF('C:Documents and SettingsDesktop[Sales Forecast -Actual.XLS]Forecast'!A186="","",'C:Documents and SettingsDesktop[Sales Forecast -Actual.XLS]Forecast'!A186)

would like to formula to be the path wherever the user saves it?

sann0638 · May 20th, 2002, 09:50 AM

If the sheet name is 6 characters, then:

=LEFT(CELL("filename"),LEN(CELL("filename"))-6)

will give you the path, including the book name. You can then use this in your if statement.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 09:42 AM	#1
Rick M New Member Join Date: Feb 2002 Location: Tampa, Fla Posts: 44	I have 2 workbooks linked together. Can the formula in book2 (be dynamic) to reflect the path the user saves book1 to? example existing formula: =IF('C:Documents and SettingsDesktop[Sales Forecast -Actual.XLS]Forecast'!A186="","",'C:Documents and SettingsDesktop[Sales Forecast -Actual.XLS]Forecast'!A186) would like to formula to be the path wherever the user saves it?

May 20th, 2002, 09:50 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	If the sheet name is 6 characters, then: =LEFT(CELL("filename"),LEN(CELL("filename"))-6) will give you the path, including the book name. You can then use this in your if statement.