VBA vlookup from another workbook by selecting

[Philip00]

Hello All!

I have the following code:

Columns("C:C").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Range("C2").Select
ActiveWindow.SmallScroll Down:=-9
ActiveCell.FormulaR1C1 = _
"=VLOOKUP([@[Domain Name]],'[Domains - DL.xlsx]Sheet1'!R2C1:R96C2,2,1)"

I would like to do VLookup but without knowing a file name.

Is there possible that to select the workbook from a window?(like when you are saving a file)

Thank You in Advance,

Philip

 

[Philip00]

Hello Guys!

I would like to clarify what i would like to do:

I would like that I can select which workbook i would like to use as a reference?

Does somebody know this?

Thank You