•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Best way to share Office Scripts?
Hi guys,
I've created a few Office Scripts for my company and want to share them with my colleagues. Here's what I'm trying to achieve:
- The scripts should run in any document (not tied to a specific workbook) and appear in the Automate gallery.
- Users should store the scripts in a folder on their own OneDrive. I tested putting the scripts on SharePoint, but every user gets annoying warnings then when running the script.
ChatGPT says I can just send the .osts files to my colleagues and they should be able to import them, but I don’t see any import button (neither in the desktop app nor the web version).
The only method that worked for a colleague was:
Automate → New Script (creates a useless file) → All Scripts → Show More Scripts → My Files → browse through a huge list of folders to find the right one → add the file.
Repeat for each script.
Is there a less terrible way to do this?
[link] [comments]
Want to read more?
Check out the full article on the original site