External Link based on cell value

[mr cruse]

Hi all, I am trying to create a external reference link based on another cell value that I can change, here is my formula -

='C:\Users\name\OneDrive\Documents\Customers'' Information\"&G23&"\[PM001.xlsm]Hidden Sheet'!$C$3

but every time I try I keep getting #REF! Any help would be greatly appreciated as it has been driving my nuts trying to work it out. Thank you in advance.

 

[johnnyL]

Is that other workbook already opened?

 

[mr cruse]

Is that other workbook already opened?

No all workbooks are closed

 

[Fluff]

In order to use a cell reference as part of the path/filename you need to use the Indirect function, but it doesn't work on closed workbooks.

 

[johnnyL]

Thank you @Fluff. That was what I was going to get to.