Code retrives https:// in Windows Explorer instead of windows explorer drive

[Cinema]

Hi,

I have the problem with ThisWorkbook.name in the following part of my code

 str_FileName = Left(ThisWorkbook.name, InStrRev(ThisWorkbook.name, ".") - 1)

Unfortunately a https:// path is retrieved for ThisWorkbook.name instead of the drive's path, which I connected correctly with Sharepoint.
The Sharepoint folder is connected with Windows explorer, which I gave the name Z:\

Had someone the same problem and know how to solve it??

[Kenneth Hobs]

Use Replace() to replace the string with the drive you want.

[Cinema]

Hi Kenneth the problem is that the drive is always different.

 Call foFS.CopyFile(ThisWorkbook.FullName, str_DestPathName, True)

How to copy the workbok without the path???

[mancubus]

http://dedicatedexcel.com/universal-...xcel-2010-vba/