I want to scan all the files on a sharepoint folder and modify them.
The issue I have is that I always get either the error 52 "Bad file name or number" at the line myfile=dir(MyPath) or the dir fucntion returns a NULL string to myfile.
The sharepoint is a secured one.
I tried to map the drive as Z: on my computer but still get the same error.
here is the code I use.
How can I have VBA to look at the files on the Sharepoint folder?Please Login or Register to view this content.
Bookmarks