Copy networked file to ThisWorkbook.Path

[MSingh]

Hi,

How can i copy a file over a network to thisworkbook.path?

I tried ..

Dim SrceFile
Dim DestFile

SrceFile = "\\Staffpc\docsStaff\Contacts.mdb"
DestFile = ThisWorkbook.path
FileCopy SrceFile, DestFile

but get Run-time Error '75':
Path/file access error

Thanks again
Mohamed

[HansV]

You have to specify the filename as well as the path:

DestFile = ThisWorkbook.path & "\Contacts.mdb"