Get the Value from a close file and file is in network drive

[Raghava@rock]

Hi Team

I need vba code that will have to fetch the value from a closed workbook which is saved in the network drive.

The problem i am facing the that the network was mapped to letter "X", but the same is mapped to different letter.


my network path is \\USXXXNN07\US-PATH

while using the this file path it is coming as X:\US-PATH.


Please help me to fetch the value from closed workbook saved in network drive.

 

[Chihiro]

Just replace the path, X:\US-PATH with your network path (\\Servername\Folder).

It should work for most functions. If it doesn't, check that path is correct by typing it into Explorer and see if you can navigate to it.

FYI - To keep drive letters consistent across company network, I recommend using Logon Script to map drives (enforced by Active Directory through Group Policy).

Without knowing your code and how it's used, hard to give you anything more than above.