Thread: Can you reference cells from another workbook in a formula?

I am trying to create a template file in Excel that will ultimately be exported as a tab delimited text file to another program.

In the template file(hereon referred to as Book_Template), I would like to take the value of a cell from another workbook (hereon referred to as Book_Source) and concatenate another string of text to it.

So in a cell in Book_Template, I have the formula:

# =CONCATENATE(([Book_Source]'Sheet_1'!$C$2),".wav")

it returns an error stating that the first arguement of the concatenate is invalid.

Does anyone know the proper syntax to reference a xls file in a formula, or is it even possible?

Thanks in advance!