Cinema
04-05-2019, 01:44 AM
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??
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??