Hej,
I like to copy some cells from a document I hyperlinked in my original document. The following code is working perfect:
Sub Perfect ()
       With Range("A1:A3")
        .Formula "='hyperlinkedFile.xlsx'!A1"
        .Value = .Value
    End With
End Sub
But I want to replace the concrete name of the document by something like
Dim File As String
File = ActiveCell.Text (or so)
to use it in
.Formula "='File'!A1"
But this is not working. Who knows the solution? :-)
I'm really glad for help
Regards
Monica