1 min readfrom 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 ScriptsShow More ScriptsMy 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?

submitted by /u/coup_de_foudre_69
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article