Dynamic closed workbook reference

[a1b2c3d4e5f6g7h8]

Hi guys,

I am trying to reference a cell in a closed workbook. So far so good. This works perfectly with fixed references like this:

Please Login or Register  to view this content.

I would like to be able to build this formula without the use of indirect to reference the month based on the worksheet name like so:

Please Login or Register  to view this content.

Any ideas on how to accomplish this?

My issues is the interpretation of strings, I think. When using the ampersand, the formula is not being interpreted correctly.

[Keebellah]

You have to use the INDIRECT() Function so you can refer to a variable, it's the filename that needs to be referenced
in VBA WorksheetFunction.Indirect()

[Keebellah]

In the German formula syntax it's INDEX()

[a1b2c3d4e5f6g7h8]

In the German formula syntax it's INDEX()

I think you are referring to "INDIREKT" which is the German synonym for "INDIRECT". INDEX works differently. Unfortunately I don't want to use a dynamic formula. Sorry, should have mentioned this in the initial post.

[Keebellah]

True my mistake.