Macro to write to Sharepoint folder

[Doghouse]

Hello all,

I currently have a macro in Excel that automatically writes the file to various places after working its magic, including a shared drive and also to a Sharepoint site. No issues with writing the file as long as we're connected to the network.

We are moving to a new Sharepoint site and I'm having trouble getting the macro to write to the new site. If I navigate to the new Sharepoint site in IE and open the folder in Windows Explorer, the file will write there no problem when we run it. I'm trying to bypass that step so that we don't need to perform that additional step several times per day (multiple folks doing this). I'm thinking I need to pass the authentication through prior to saving, but I'm not finding much out there for guidance.

Here is the structure for how I'm showing the paths:

spath = "\\oldsp\subfolder\subfolder\subfolder\subfolder" 'Path for the old Sharepoint site
ipath = "\\folder\subfolder\subfolder\subfolder\subfolder\subfolder" 'Path for the Shared drive"
tpath = "\\folder.site.com\subfolder\subfolder\subfolder\subfolder" 'new Sharepoint Path

Any suggestions?

Thanks in advance.

 

[=ODIN=]

I'ts been a while since I used SharePoint, but maybe if you map the new site as a network drive and then use that as your path reference it might work.