I am trying to create a link that changes with the date entered in C1
Original Link =‘file:///C:/2018Document.ods’#$heet1.A1
Attempted Link =‘file:///C:/’ & C1 & ‘Document.ods’#$heet1.A1
but that is converted to =‘file:///C:’ & C1 & ‘file:///C:Document.ods’#$Sheet1.A1
Any help is appreciated.
A reference is not the string it is represented by. If you have concatenated the string you need to apply the function INDIRECT() to convert it to the reference.
In addition: string constants you want to calculate with need to be marked by doublequotes.
Try =INDIRECT("'file:///C:/" & C1 & "Document.ods'#$heet1.A1").
Thank you, Lupp! That is exactly what I was looking for. I had seen the Indirect Function but did not associate it properly. I will need to read more. Thank you again.