Copy text from formula and paste as external reference in VBA

Hi,

I would like to ask for help in creating a macro that will copy text from the formula (which creates the path of external reference) and paste it in another cell as an active external reference. When recording a macro, this will be something like this

Please Login or Register  to view this content.

but with dynamic change of parts 'J:\folder\[file.xlsx]k'!R22C39 comes from cell formula.

Thanks in advance !

Paul

Why something like this does not works?

Please Login or Register  to view this content.

when Range("F7") is text 'J:\folder\[file.xlsx]k'!R22C39