Open file from network drive

[Bubo]

Hi,

I have a workbook located on my local laptop. The workbook contains a procedure that opens some excel source files from a network folder and copies data to the local workbook.

The issue is that the I need to change the drive in order to open the source file and I have no clue how to change the drive from local drive to network.

The folder is not mapped to a drive-letter. I would avoid mapping the folder, since a other users use a same workbook with the same code on their laptop assessing the same files.

Could anyone help me on this.

ChDrive ???
ChDir sFileDirectory

Thanks,
Bubo

 

[jindon]

If you are to open a file in shared folder in a network then try

Dim myDir As String
myDir = "\\xxx\yyy"  '<- change here
CreateObject("WScript.Shell").CurrentDirectory = myDir
MsgBox CurDir
End Sub

 

[Bubo]

Many thanks! It works great!

Greeting from Budapest, Bubo