Files not saving to newly created folder on OneDrive by VBA

[tobyolivernash]

Hi,

I need to create a whole bunch of folders as part of a regular exercise and then save newly created files into those folders.

I've tried using MkDir and the "file system object" ways of creating a new folder onto a OneDrive location using VBA.

The folder creates just fine, it's just that I can't save any files into them!

I just get the error, document not saved.

First I thought it was my VBA code and not getting the save as method right but even when I try manually saving any files into the newly created folders, it comes up with that error.

I can create new folders manually onto the OneDrive and that works fine, its just via VBA using MkDir or FSO methods that it doesn't like.

I was wondering if anyone had any other ideas?

 

[JLGWhiz]

Should not be a problem with vba if you have the correct path to the directory on OneDrive. Make sure your vba path is mapped correctly from your system to the OneDrive server.