Saving a Macro as new FN to a cloud drive

[KatieB1986]

I work at a small company and have been tasked with setting up a new invoice system. The company currently uses OneDrive to save files as that is what my colleagues are comfortable using and allows access from home. Basic i know, but for what we do it works well.

The invoice is currently a work in progress but currently using Excel with a database, vlookup and save as new file name set up which is great. However, with every computer the file destination changes.

My question is, how do I save a macro so that others using the Onedrive can edit and save without having to alt+F11 and change the file path each time?

 

[Tim_Excel_]

To answer this question, we have to know what the fixed values for the path are. Is there a common folder for the office that everyone uses?
It would be relatively easy to code something when the path would look something like

/General Company Folder/User Folder

If this is not the case, are you allowed to make new folders on the OneDrive? This way you can add a folder for each user in VBA. This would be easily achievable by having the user type in their name in a userbox, and using this value in the path.