Is there a function that references a workbook's name?
B Bob Phillips Aug 10, 2006 #2 See http://www.xldynamic.com/source/xld.xlFAQ0002.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
See http://www.xldynamic.com/source/xld.xlFAQ0002.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
B Barb Reinhardt Aug 10, 2006 #3 Are you saying you want to have the workbook name show up in your worksheet somewhere? If so, use the CELL function Try something like this =CELL("filename",A1) You can parse out the workbook name from that
Are you saying you want to have the workbook name show up in your worksheet somewhere? If so, use the CELL function Try something like this =CELL("filename",A1) You can parse out the workbook name from that
P PCLIVE Aug 10, 2006 #4 Not sure exactly what you're asking, but this is how to refer to cell A1 of Sheet 1 in a workbook with a file name of "Test.xls". ='[Test.xls]Sheet1'!$A$1
Not sure exactly what you're asking, but this is how to refer to cell A1 of Sheet 1 in a workbook with a file name of "Test.xls". ='[Test.xls]Sheet1'!$A$1
