• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlook up closed workbook

As I have stated previously. You can't access closed workbook using VLOOKUP function, when the workbook is in network drive, without letter assignment. This holds true, even if VLOOKUP is used as WorksheetFunction in VBA.

Test if below code at least succeeds in opening the workbook in network drive.
Code: 
Sub test()
Workbooks.Open ("\\delindp08\Suhas\Look.xlsb")
End Sub
 
You must log in or register to reply here.
Back
Top