Vlookup is prompting to select the sheet in VBA

[sharmila Krishnamurthy]

HI, Thanks for your help in advance

I have created a code to vlookup the values from the other sheets in VBA. But the code is asking to select the file while executing
'Vlookup of data
>>> use code - tags <<<

Range("O2").Select
ActiveCell.FormulaR1C1 = _
        "=VLOOKUP(RC[-11],'[JLG_NET_DISB.xlsm]Sheet1'!R2C2:R100000C45,28,0)"
Range("O2").Copy
Range("O3:O" & Lrw).PasteSpecial
Range("P2").Select
ActiveCell.FormulaR1C1 = _
        "=VLOOKUP(RC[-12],'[JLG_NET_DISB.xlsm]Sheet1'!R2C2:R100000C45,44,0)"
ActiveCell.Offset(0, 2).FormulaR1C1 = _
        "=VLOOKUP(RC[-14],'[JLG_NET_DISB.xlsm]Sheet1'!R2C2:R100000C55,53,0)"

Running the macro JLG_NET_DISBV2.0, code is asking to select the file, where as I already mentioned the sheet details in the line of code itself.

Thanks
Sharmila

 

[vletm]

sharmila Krishnamurthy
Your ... code tagged code ... has refer to [JLG_NET_DISB.xlsm]
.. and one of Your sample file's name is JLG_NET_DISBv2.0.xlsm
... then Excel as You would ask same thing.

 

[sharmila Krishnamurthy]

sharmila Krishnamurthy
Your ... code tagged code ... has refer to [JLG_NET_DISB.xlsm]
.. and one of Your sample file's name is JLG_NET_DISBv2.0.xlsm
... then Excel as You would ask same thing.

 

[sharmila Krishnamurthy]

Thanks Much Vletm. Don't know how would I missed, such simple thing.