VBA path issue

[teowchy]

Please Login or Register  to view this content.

Above script running, will be asked to open an excel to update values, Cells(Target.Row, 4) = "=VLOOKUP(" & Target.Address & ", 'strPath'!$C:$H,5,0)"
the value of the strPath already is \\Server\test\[WSO_Record.xls]Record
But still need to manually specify an EXCEL file to update source, why?

If I put the direct network path to the script, it running well Cells(Target.Row, 4) = "=VLOOKUP(" & Target.Address & ", '\\Server\test\[WSO_Record.xls]Record'!$C:$H,5,0)"
Or put my computer path also no problem Cells(Target.Row, 4) = "=VLOOKUP(" & Target.Address & ", 'D:\test\[WSO_Record]Record'!$C:$H,5,0)"


Moderator's Note: Welcome to the forum, you have to put code tags around your code. Selct the code then hit the "#" symbol. I'll do it for you now. Thank you.

[haripopuri]

Try this.

Please Login or Register  to view this content.

[teowchy]

it's work fine, thank you

Try this.

Please Login or Register  to view this content.

[haripopuri]

Glad I could help. Please update the status of thread as [solved]