Excel vba export csv to onedrive works perfectly on my machine but not on clients who has share

[tonymaclaren]

I desperately hope someone can help.I have some simple VBA code that makes a copy of a worksheet and saves it to a shared folder on Business OneDrive, the main bit of code is just:

Sheets("Data").Select
Sheets("Data").Copy

ActiveWorkbook.SaveAs Filename:="https:// blah /bla".
, FileFormat:=6, CreateBackup:=False

It works perfectly.BUT when I share the folder for my client, it asks for credentials for the correct directory on OneDrive and then gives the error error "1004 method save as of object workbook failed". I should add the client can view the same shared directory and upload the same file manually with no problem whatsoever !

It is not a .csv problem as I originally thought because the same problem occurs with .xlsx in testing.

 

[Kamolga]

Maybe

[LEFT][COLOR=#333333][FONT=Verdana]ActiveWorkbook.SaveAs Filename:="https:// blah /bla".[/FONT][/COLOR]
[COLOR=#333333][FONT=Verdana], FileFormat:=6, CreateBackup:=False, [/FONT][/COLOR][/LEFT][COLOR=#0000ff][LEFT][FONT=Verdana]accessmode:=xlShared[/FONT][/LEFT][/COLOR][LEFT][COLOR=#333333][FONT=Verdana][/FONT][/COLOR][/LEFT]

 

[tonymaclaren]

Thank you Kamolga. That does not work at all. It compiles but throws the 1004 error even on my machine.
FileFormat:=6, CreateBackup:=False, _
accessmode:=xlShared

accessmode:=xlExclusive works on my machine burt not on the clients.

 

[Kamolga]

Maybe save to

[LEFT]"c:\User\[I]OneDrive[/I]\…"[/LEFT]

instead of

 "https://d.docs.live.net/..."

Or you could open a OneDrive document online or open OneDrive online. Then get the cid of the url.E.g. https://onedrive.live.com/?id=root&cid=89599CF5610D3147
?​

 

[tonymaclaren]

CID approach will not work with business OneDrive.Personal only