Excel Headlines

New article: Enabling Drag and Drop between two Listboxes on a VBA Userform
I have added a new article today which shows how to enable drag and drop between two listboxes on an Excel userform
Wed, 10 June 2020 10:30:00 GMT

Nieuw artikel: Gegevenstypen gebruiken in Excel
Ik heb een artikel toegevoegd over het gebruik van Gegevenstypen in Excel.
Thu, 21 May 2020 16:00:00 GMT

Nieuw: ons Excel Forum
Wij kregen tamelijk veel Excel gerelateerde vragen in onze commentaren. Om deze vragen beter te kunnen kanaliseren zijn we daarom een Excel forum gestart. Heb je een vraag? Word lid van ons forum en stel hem hier: Excel Experts Nederland Forum
Mon, 30 Jan 2017 16:38:13 +0000

Excel VBA Masterclass
Hi there. Hope you and yours are well in these difficult times! This is just a very short announcement that I’ll be doing an on-line version of my Excel VBA Masterclass. The training is scheduled for May 18, 20, 26, 28, June 2, 4 and I’ll be using Microsoft Teams to deliver it to your […]
Mon, 27 Apr 2020 09:48:35 +0000

It’s (past) time to speak out

Earlier this week, in a private forum, one of my colleagues took a friendly joke thread and dropped a horrible MeToo joke in it. I was astounded, incredulous and disgusted. But I said nothing. Another MVP called him out, and … Continue reading →

The post It’s (past) time to speak out appeared first on The Excelguru Blog.

Thu, 25 Jun 2020 18:03:26 +0000

Use Power Query to Manipulate Your Data

Power Query (Get & Transform) is a powerful yet easy technique for manipulating data in Excel. This example shows how to prepare data for a box plot.

The post Use Power Query to Manipulate Your Data appeared first on Peltier Tech Blog.

Thu, 07 May 2020 13:57:08 +0000

Excel Search Form Builder Update 2020-06

Written by Debra Dalgleish from Contextures Blog

There's been an update to my Excel Search Form Builder (SFB), so download the latest version if you've bought this product before. In version 4.08 you can create a form with either 2 or 4 search boxes. Previously, there were only 2. Note: If you don't have the Search Form Builder yet, it's in the … Continue reading "Excel Search Form Builder Update 2020-06"

Excel Search Form Builder Update 2020-06 is a post from Contextures Blog and is not allowed to be copied to other sites

Thu, 25 Jun 2020 04:01:00 +0000

Office Scripts: Announcing a simplified API, Power Automate support, and sharing

Office Scripts have been available for preview in Excel on the Web for over six months now. Today, we are excited to announce that Office Scripts have received several significant updates, including (1) a simplified API, (2) the ability to run Office Scripts via Power Automate, and (3) the ability to share scripts with others in your organization.

 

Simplified API

Office Scripts relies on Office JS, a set of APIs that allow developers to interface with Excel—usually to create Add-ins. With Office Scripts, we wanted to ensure that the immense benefits of automation would be available to all Excel users, not just those with highly advanced programming knowledge. In pursuit of that goal, we’ve taken significant steps to simplify these APIs and to make them more approachable and intuitive.

Some highlights:

• Office Scripts APIs can be invoked in a synchronous manner without having to worry about programming concepts such as promises or callbacks.
• Easier API design that includes simple object collections, getter and setter methods for property access, better error handling options, etc.
• Improved APIs to interact with Excel objects such as range cell, table rows and columns.
• Development time static type checks offered by TypeScript language-based IntelliSense.

Read more about the newly simplified APIs for Office Scripts

 

Run Office Scripts via Power Automate

 

One of the things we’ve heard on countless occasions from our users is the desire to be able to schedule scripts, to trigger scripts based on a particular event, and to interface with other services and products than just Excel. As of today, all of that is now possible through Power Automate.

For those unfamiliar, Power Automate is a Microsoft product and platform which allows you to create automated workflows. Each of these “flows� contains a trigger and one or many connectors. Triggers define when a flow will execute—for example, every Monday at 10am—and connectors define what actions will occur. Connectors can perform actions across a whole host of different tools and services, from Microsoft offerings like sending an email in Outlook, to 3^rd party platforms like fetching tweets from Twitter. All of this can be accomplished with little to no code.

For some time now, the Excel Online (Business) connector has allowed users to create flows that read and write data to tables in Excel workbooks. With the addition of the “Run script� action, you can now automate almost any task available in Excel on the Web—and set it up to run without you ever having to intervene manually. As of today, if you can record or write an Office Script that accomplishes a task you might otherwise do by hand, you can now accomplish that task regularly without ever having to open Excel.

Some examples of what you can accomplish:

• Sending an email status report to one's broader team every Monday at 9am
• Processing data submitted to Microsoft Forms and visualizing it using Excel's charting engine
• Storing information about tweets which include a particular hashtag in a spreadsheet, then alerting a Teams channel about the update
• Examining a team's status tracking spreadsheet for completion and sending a both email and teams reminders to colleagues who have yet to complete their assigned sections
• Fetching issue data from a GitHub repository and summarizing and visualizing it for use in a report

Read more about using Office Scripts with Power Automate

 

Share scripts with others in your organization

Office Scripts can now be shared with other users of an Excel workbook. When you share a script in a workbook, the script is attached to the workbook and is visible to and runnable by anyone with whom the workbook is shared.

This is an immensely powerful collaboration tool for organizations; while not everyone may be motivated enough to learn to code and to automate their work with Office Scripts, now, team members can leverage the ingenuity and hard work of those that are.

Read more about sharing Office Scripts in Excel on the Web

 

Next Steps

Please feel encouraged to reach out to us! Office Scripts is still in preview, and your input is critical to the team’s ability to offer something truly great.

 

• If you have any feedback or suggestions for the new Office Scripts feature, please let us know via User Voice.
• If you get stuck, or have any questions about how to accomplish something, please ask questions on StackOverflow under the “office-scriptsâ€� tag.
• If you run into problems with the Script Recorder or one of the APIs, please send us feedback via the Help > Feedback button in Excel for the Web.

 

Happy Office Scripting!

Wed, Jul 01 2020 11:51:47 +0000