Correct save path and syntax to save workbookdirectly into ONEDRIVE subfolder

Hi everyone, some words of wisdom please....

I have a workbook with several sheets and macros. Some of these macros attempt to save/open files to/from a subfolder inside a local ONEDRIVE folder.
I need to be able to set this up on multiple machines (all with different OneDrive accounts)and for them all to work.....

When I test the following on a 'dummy' onedrive folder (that is not actually connected to OneDrive) this path/address it works.

Trying it on a 'real live' onedrive folder gives me an error.

Please Login or Register  to view this content.

I have also tried this with no sucess

Please Login or Register  to view this content.

and this is broken too .... ;(

Please Login or Register  to view this content.

Please can anyone help?

Many thanks in advance :

Gideon

If your system is anything like mine, the folder is actually SkyDrive, not OneDrive.

C:\Users\...username...\SkyDrive


Regards, TMS

Yep, that's it on my system ... change OneDrive to SkyDrive

Regards, TMS

It appears as OneDrive in Windows Explorer but, if you select the folder and then click in the folder selection box, you will probably see it says SkyDrive.

But, one easy way to check ... change it in your code and test it. Your choice

See the image ...

SkyDrive.jpg

Sorry, that was the best shot. Changing your code worked for me in terms of saving a file directly into the OneDrive/SkyDrive folder.

The only difference was that I wasn't trying to build a file name from the contents of cells. Itt could be that the combination of cell contents doesn't make an acceptable folder/file name.

I note that this:

Please Login or Register  to view this content.

appears to be wrong.

I'd expect

Please Login or Register  to view this content.

You also refer to !Registers in one example and !Reports in another. Are both those folders present?

Regards, TMS

Thanks for sharing.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.