Forum Discussion
Excel vba export csv to onedrive works perfectly on my machine but not on clients who has share
I desperately hope someone can help.I have some simple VBA code that makes a copy of a single worksheet and saves it to a shared folder on Business OneDrive, the main bit of code is just: ...
Does the user have this Shared OneDrive folder available as a synching folder in his OneDrive folder on his computer? That may fix things.
Thank you for your reply.This is an interesting suggestion, however I am not quite sure how to implement it. If you could walk me through it would be helpful.The workbook is a standalone app that exports the single "Data" worksheet to MY business OneDrive with VBA. How do I synch MY OneDrive URL directory to the users PC?
- It means the user would have to install OneDrive and sign into the account on which he has access to your shared folder. I am not entirely sure however that shared folders are available as synched folders in the OneDrive app.