Announcing buttons for Office Scripts: Run scripts with a workbook button
Starting today, you—and your colleagues—can run Office Scripts by pressing a button within a workbook. This highly requested feature introduces a new way to share scripts with colleagues, making it easier for users to find and run your scripts.Automate your tasks with the Automate tab—now in Excel for Windows and Mac
The Automate tab is growing beyond your web browser and onto your desktop! Starting today, the Automate tab is now available for all eligible users in Excel for Windows and Mac. Previously, this tab was only available in Excel on the web.Office Scripts is now available for Office 365 Enterprise E1 and Office 365 F3 licenses
We are happy to announce that Office Scripts in Excel is now available for customers with Office 365 Enterprise E1 and Office 365 F3! Starting today you can find the Office Scripts feature set in the Automate tab on the Excel ribbon.
Shared office scripts - Needs premission everytime it's executed
I wrote some office scripts in some excel workbooks. Those scripts are executed by pressing a button created with what excel provides. Co-workers in my company are supposed to use these scripts frequently. Whenever they execute any script they are being asked if they trust the author, then they press allow and the scripts executes. As far as I can tell this message (of trust) is supposed to be asked just for the first time any script is executed or after anything changed with a script. However in my company they are being asked everything single time (even after nothing changed or repeating executions after another with any same script). We already tested some stuff in the Trust Center but no success yet. What can I do to just get the message once or after every update of the script? Note: This behavior even takes place with scripts that just print "Hello World" in the console.
Automate tab not appearing even though I meet the requirements in the Learn article
The account I'm using Microsoft Office with is part of a Microsoft 365 Family subscription, and according to https://learn.microsoft.com/en-us/office/dev/scripts/testing/platform-limits?tabs=home#platform-support, signing up to the Microsoft 365 Insider program and enabling connected experiences should be enough for me to start being able to use Office Scripts, but sadly the Automate tab still won't show up for me. I've enabled the option for it in the Customize Ribbons category of the Options menu, and have tried reinstalling Office and using both the Preview and Beta channels, to no avail. Has anyone else had issues with the Automate tab not showing up while using a Family Subscription? If so, did you manage to fix them? Thank you!Converter, VBA to Office Script.
A converter VBA to Office Script is a challenging task, but with VBA and regular expressions, many common VBA constructs can be converted to Office Scripts. This converter is intended to create an approach in Office Script and then the user can extend it with his knowledge. Since VBA and Office Scripts have different syntax and APIs, this converter will convert simple elements such as loops, conditions, and cell operations. A more complex VBA to Office Scripts converter requires advanced logic to analyze and convert the different syntax and commands of the two languages. The attached file tries to convert the VBA code into Office Script in a simple way. A lot of things are not taken into account, but it can be a useful tool to get started. I hope it works for you too and if you discover any problems or errors, I would be happy to hear your feedback.
