Say Goodbye to Boring Excel Tasks: Create Cool Buttons to Run Office Scripts from ANYWHERE
HTML-код
- Опубликовано: 23 июл 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
An Office Script is the new way to automate boring tasks in Excel. You can run these scripts on the web, in Microsoft Teams and even on your desktop. Now you can help your colleagues find and run your Office Scripts by adding a cool button to your workbooks. Not only does this make it easy for others to run the script, but the script is available automatically to anyone you share this workbook with. This way you do not need a macro-enabled workbook to run the automation.
Key Highlights:
- Introduction to Office Scripts: Understand what Office Scripts are and how they can replace traditional macros, offering flexibility and ease of use across various platforms.
- Cross-Platform Compatibility: Learn how you can run scripts not only in Excel on the web but also in Microsoft Teams and even on the desktop version of Excel.
- Interactive Button Creation: Explore how to add visually appealing, clickable buttons to your Excel sheets, making script execution easy and intuitive for anyone.
- Real-World Application: Follow a practical demonstration where we automate the formatting process across multiple worksheets with just a few clicks.
- Editing and Customization: Gain insights into customizing buttons and editing scripts to suit your specific needs, enhancing your Excel experience.
- Script Accessibility: Find out the important requirement of having your files on SharePoint or OneDrive to access and run Office Scripts effectively.
- Hands-On Tutorial: Walk through a step-by-step guide to recording an Office Script from scratch, making your spreadsheets more dynamic and efficient.
- Sharing and Collaboration: Understand how these scripts enhance collaboration, allowing shared access and execution within Teams and across platforms.
In this video, I'll show you how you can record a script to loop through an entire workbook to apply a specific formatting. Then we'll assign the script to a button.
🌍 My Online Courses ► www.xelplus.com/courses/
00:00 Create a Button to Run an Office Script
00:37 Important Information About Scripts
02:35 Record an Office Script
04:27 Create and Modify the Button
05:39 How to Edit the Office Script
08:30 More Information about Scripts
09:04 Running the Office Script
10:52 Wrap Up
🎬 LINKS to related videos:
Introduction to Office Scripts: • Introduction to Office...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #officescripts
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
I love you! I have taken your VBA class as well as others and have learned a ton. This is definitely my next task for automating our processes. Thank you!!!!
I've been using scripts for up to 5 years now, and applied them with buttons for almost 3 years now. I use it mostly for doing routine monthly formating and generate financial reports within seconds. I also use them to filter and print (in pdf or paper) those reports without having to literally go to the filter drop down or select the specific printer and number of page I want to print. Buttons and scripts have saved me a couple of days at work and lot's of frustration to be honest.
How can i learn scripts quick?
@@abdullahalnaiem3501 by copying them 😜
I consider myself pretty competent with Excel and VBA. I must say you have upped my game considerably... you are a treasure which I just discovered recently
Many thanks. Productivity-enhancing knowledge, well-presented.
As usual.
Thanks Leila, another great video! I never knew much about scripts.
Please make more Office Script videos!! This is a fantastic new tool and i really want to learn how to use it in more scenarios!
Oh I love this. Now this is gonna help me a lot. Thanks lady
Thank you for sharing! Have a nice day!
I am your big fan, you are an awesome teacher!
Thank you for sharing... ❤️
looking forward to a full length course for office script just the way you did for VBA, I've become quite comfortable and proficient after taking your courses !
Great video. Thank you!
Could you create a tutorial how to use message box in office scripts? So that user could define content of variable by answering to a box instead of writing it to specific cell.
you're a lifesaver!
Great information just like always, thank you so much dear Leila
Very useful thanks
Thanks
Thank you Leila
Very interesting. It would be nice to present the Office scenarios as an infographic.
Awesome !
Been doing this for a while, it's very useful
Love this!! Thank you so very much, Leila!! One thing, the script I recorded is perfect and runs like a dream. However, I needed to move the newly created (run script) button to another tab. Once I did so, the script runs only on the sheet where the button is located. How do I click the button on one tab and get it to run on, say, "Sheet1" of the workbook?
Office scripts are essentially just JavaScript with some Office-specific functions, so it's easy to use the scripting elsewhere too. It's a transferable skill.
Great video and it could help with some of our processes. But our organization has a mix of Business Premium and Business Basic accounts. Only the Business Premium accounts have access to automate in Excel. If a Premium user creates a script for a spreadsheet and shares it with a Basic user with full edit permissions, would the Basic user be able to run the scripts?
Very interesting video.
I have a question: Office script run on smartphone or pad?
Thanks and see you next
4:49 I don't have "Add button" option here. The options I have are: Delete, Rename, Automate a task. I have a 365 business suscription. Do you know why I don't have this option? Is any way to activate it or another way of adding buttons?
hi
I love it.
I only have one comment.
when changing from a single sheet operation to for loop on all sheets, instead of changing all "SelecteSheet" to "W", I would change to loop variable "W" to SelectedSheet. I also think using a name of a single letter like "w" is not a good practice.
Thanks.
Thankyou for sharing, nice presentation. Do I Need to subscribe to access "automate" and record macro? and can it be run via phone? the goal is to create office files and can access by phone and do some automation anytime anywhere . Thankyou, learning a lot from your videos, subscribed and will definitely stay tuned.
please make a video on excel symbols and their meanings so i can understand and customize the formulas like what is meant by " " these in a formula.... Or if we want to use and in the function like this and (+) this how we use it. Basically its about symbols that were used in excel formulas... $ this one & this one ..
Hi is there a way to use one script file only for multiple buttons. I have a worksheet that has multiple buttons and this also has multiple script files. Although you can add multiple functions in a single script but It can't call the other functions without running the main function
Using office scripts after converting csv I am emailed to xlsx in power automate then creating a table so power automate can read data and add to SharePoint etc
This is great. I haven't tried using scripts yet, but I am looking forward. I need to see benefit of scripts vs VBA, so maybe I should create a script, which could replace my existing macros.
I'd be curious to hear about your findings 🙂
I've recorded simple script in online Excel version and saved file to OneDrive desktop, but script button didn't work. Maybe not all Excel 365 versions support scripts
Got 2 questions,
Will the scripts still work if you share them outside your organisation?
And is it possible to protect your document that people can use the script but not change them?
Thanks already!
Can you share scripts for Google forms. I would like send a customized email to the customer as soon as the submit button on goggle form.
Any short cuts to remove only special characters from the text or sentence?
Can I use Office script in any 365 version?
I love vba but I am loving scripts so far, it will take some time to get used to it but I'm in...
I do have a question... I did my first script on an excel sheet, when i run it manually it runs immediately however when I run it from the button it takes more than a minute to run. what culd be the cause?
The script unlocks the excel FORM, and blanks all fields then lock the sheet again 🤔
Are office scripts going to be a thing outside of SharePoint or OneDrive?
Please make video on dashboard. Outlook excel dashboard
It seems you have to have an organizational account for this to work. Not for private users?
" ... these files are on SharePoint ...".
Very timely ...
But alas, I am a novice 'scripts' student. My scripts look like a kindergarten's first reader, i.e., "... See Spot run. Run. Run. Run ..." ... while Leila's scripts (to me) read like Shakespeare. But with Leila as the teacher, I continue to dream that someday I too will be able to write great lines of prose. She is a terrific instructor ... always patient ... always available … always helpful.
Thank you ... thank you ... thank you .... 😍😍
@Leila does it work on MacOS excel app?
Hi Thank you , question i have pms file i want to know is there any way to excel calculate by own and find 3rd date between start and finish date with formula and gives best match date between 2 start and finish date , it's example that can expand for 1000 tasks
Imagine i have 3 tasks with 5 days duration start is 1/1/22 and finish is 1/12/22 so first task start 1 day and 3rd task start 1/7/22 now I want excel calculate and find best date between in 2 tasks that must be 1/4/22
Now is there anyway excel calculate and find this date, this is can use for 1000 tasks more or less that I need to find it
1000000 tnx if you help me 🌹🌹🌹🌹
Thank you 🌹🌹
omg the frustration. Cant find it anywhere. Where do you find or add the button Automate?
Hello can anyone help me that how I can assign keyboard shortcut to my subprocedure or macro using VBA in PowerPoint
Hi Lelia,
i am getting below error while running your script. Can u plz help me out.
Cannot read properties of undefined (reading '0')
I have not been able to find a way to PRINT from Office Scripts - nice to have a button that says "Print" and uses the default printer. But, seems like this is only in Desktop VBA mode (which we are trying to move away from)
Dear Leila. I want the dates looking like this 24/05/2020 and not 24/5/2020. How can I achieve it?
Hi Leila and everyone.
Does anybody know why I am missing " + Add button" on my version of Excel online, show at 04:37?
Does anybody know how I can enable it?
This could be your greatest video of all time.
But I do wish Excel online would do subtotals!
Expecting your new course on Udemy.
What should we do if we don't see the "Add button" under more options?
Great! It looks like to a macros. What is the difference between script & macros?
Maybe this is helpful: ruclips.net/video/DOvHqukAGTY/видео.html
@@LeilaGharani I have go to the link on difference between VBA and script. It's very helpful. As the video for difference of VBA and script is a year ago. Things that script can't do, I see you are able to do now like create a button and insert the script. How about pop up message and event?
Currently, script about to do?
Currently, I m using VBA but maybe I will switch to script in a correct timing.
So basically these are Macros on the the Server side, right?
aku rasa bagus apabila menggunakan google sheet dan berikan secara langsung agar kami langsung memakainya ( mohon di buatkan saya dari indonesia )
Line 46: Cannot read properties of undefined (reading '0')
So can we soon expect a scripts course coming?!? :)
Not "soon" but yeah, I definitely want to create one 😁
Office scripts 101 maybe, Leila
I wish Microsoft kept VBA. Office scripts looks complicated
Can you help me?
I have data in sheet2
I want to put new data row of 15 cells in sheet1
I want it to go to sheet2 in last row
N
Continue with my new data
See this video which shows you how to add data to the last row of a table:
ruclips.net/video/xWPnQhJJ8H8/видео.html
First I'm hearing of office scripts. I've always used vba. I'm not sure I like the idea of saving the script outside the document, if it's for a document it should be saved with that document.
Are office scripts different from VBA?
They have the same purpose but also work on the web. Here's an explanation of the difference: ruclips.net/video/DOvHqukAGTY/видео.html
these script works on MAc excel
i am open to new solutions...but when they want vba people to change...they should at least give us a full screen IDE...for debugging and so on...
i am learning javascript, but the language is too full of {}{}{}... vba is much clearer to me...
i am exited how far Office Script will get
You can drag the Code Editor across to the left taking up the whole screen. There is discussion, at this time, I believe, on having Office Scripts within Visual Studio Code. The "Learn the Basics" documents, as mentioned by Leila, are extremely good and will get you very productive very quickly. Given most businesses are using cloud tools, including Office 365, VBA is less and less used. Millions of VBA scripts will need rewriting to Office Scripts if the owners want them to run on cloud files. Though that said, Power Automate Desktop does allow a work around for that! See this video:
ruclips.net/video/owI4LyQb2xE/видео.html
Jeen Yuhs
Can I pay for for 30min of training?
I used to work with Photoshop and seems that Microsoft learns from Adobe Photoshop Action which records all the actions to create our own photoshop action or in this case, MS Office script.
ruclips.net/video/a8KMITn1Qwg/видео.html 😆
Welcome to the world of Microsoft. VBA has been around since 1996 or earlier! And the F4 button is, also, a mini macro facility. Office Scripts fills the macro void that existed for Excel Online.
Beautiful gorgeous woman and SMART 🤓 ❤
"There are no secrets to success. It is the result of preparation, hard work, and learning from failure."
-- Colin Powell,,,,,
Definitely interesting but I was really hoping scripts would be standalone at some point. Happy but also kinda disappointed. :(
Congratulations ... it can now almost do what VBA have been able to do for 30 years...
I really hate Microsoft forcing you to use their cloud to access a simple scripting feature. (Running simple code like this takes like 0.01 seconds for a bad cpu) This is only to lock users in their ecosystem, and prevents anyone (company/individuals) to integrate excel in a broader set of tools they own. As a consumer, you don't really own the product you bought, as it's still administered by the company you bought it from.
Finally we don't need to learn fucking visual basics just for excel automation...
...🤣 are you for real?
VBA is still much more powerful than this...
i dont hate JS, but it is a Web-Language. it would be beneficial when everything in office is web-based.
but do i really want all my data and company data on microsoft servers??? i dont think so...
@@kolavithonduraski5031 exactly Not a chance. Also why I will never own a 365, well nobody will ever own it. Software on my hardware, not theirs!
@@kolavithonduraski5031 When you create your Microsoft Office 365 account it is based on geographic location. So, if you are in the US then your data will be stored in the US. If you create your account in France, your data is stored in "West Europe" and under the regulatory and legal control of the European Union - i.e. GDPR. Microsoft has no access to your data in any case. The only issue that has ever arisen in this matter is the US government stealing consumer's data. GDPR and more recent EU law seeks to counter this malicious US Government activity. Anecdotally, I have heard/read, of all the cloud service providers Microsoft is the most secure. Though I am not a security expert.
@@ChrisS-if7ev The world started moving to the cloud many years ago. Data Centres will be soon, the only way you are allowed to use software. Your country will make it law. Sharing physical resources via a data centre, for example, negates the need for millions of power hungry devices (laptops) when only one data centre (self-powered using geothermal/solar) is needed. All countries are now, facing an energy crises. Raw materials, too, for smart devices, are about to run out or be restricted by countries self-preserving their own needs. Soon, there will be no new smart devices. This is the reality we all need to think about and prepare for. Dumb Terminals (with Office Scripts) and Data Centres is the future. You better start learning Office Scripts. 🤖
@@johnfromireland7551 Won't happen. I will use a outdated version, hacked if need be on my own enviornment. Kind of like I refused to use Adobes online tools. I still run Adobe in my own ecosystem.