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.
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
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!!!!
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.
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?
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.
" ... 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 .... 😍😍
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 !
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?
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.
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!
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 ..
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
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.
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: czcams.com/video/owI4LyQb2xE/video.html
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 🤔
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'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
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?
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 🌹🌹
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)
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.
@@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.
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?
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
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.
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.
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
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.
...🤣 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 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.
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
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
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!
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!!!!
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.
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?
Oh I love this. Now this is gonna help me a lot. Thanks lady
Very interesting. It would be nice to present the Office scenarios as an infographic.
you're a lifesaver!
Many thanks. Productivity-enhancing knowledge, well-presented.
As usual.
Thanks Leila, another great video! I never knew much about scripts.
Thank you for sharing! Have a nice day!
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.
omg the frustration. Cant find it anywhere. Where do you find or add the button Automate?
" ... 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 .... 😍😍
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 !
I am your big fan, you are an awesome teacher!
Thanks
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?
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.
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!
Thank you for sharing... ❤️
This could be your greatest video of all time.
But I do wish Excel online would do subtotals!
Very interesting video.
I have a question: Office script run on smartphone or pad?
Thanks and see you next
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?
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 ..
Thank you Leila
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
Great information just like always, thank you so much dear Leila
Very useful 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.
Any short cuts to remove only special characters from the text or sentence?
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:
czcams.com/video/owI4LyQb2xE/video.html
Is it possible to rename files after office script ran?
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 🤔
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
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?
What should we do if we don't see the "Add button" under more options?
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 🌹🌹
Can I use Office script in any 365 version?
Are office scripts different from VBA?
They have the same purpose but also work on the web. Here's an explanation of the difference: czcams.com/video/DOvHqukAGTY/video.html
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
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)
So basically these are Macros on the the Server side, right?
Expecting your new course on Udemy.
Been doing this for a while, it's very useful
Are office scripts going to be a thing outside of SharePoint or OneDrive?
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.
Great! It looks like to a macros. What is the difference between script & macros?
Maybe this is helpful: czcams.com/video/DOvHqukAGTY/video.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.
aku rasa bagus apabila menggunakan google sheet dan berikan secara langsung agar kami langsung memakainya ( mohon di buatkan saya dari indonesia )
Dear Leila. I want the dates looking like this 24/05/2020 and not 24/5/2020. How can I achieve it?
Awesome !
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?
Line 46: Cannot read properties of undefined (reading '0')
Hello can anyone help me that how I can assign keyboard shortcut to my subprocedure or macro using VBA in PowerPoint
these script works on MAc excel
Hi Lelia,
i am getting below error while running your script. Can u plz help me out.
Cannot read properties of undefined (reading '0')
Can I pay for for 30min of training?
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
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.
Congratulations ... it can now almost do what VBA have been able to do for 30 years...
Beautiful gorgeous woman and SMART 🤓 ❤
@Leila does it work on MacOS excel app?
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.
czcams.com/video/a8KMITn1Qwg/video.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.
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:
czcams.com/video/xWPnQhJJ8H8/video.html
Jeen Yuhs
"There are no secrets to success. It is the result of preparation, hard work, and learning from failure."
-- Colin Powell,,,,,
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.
Definitely interesting but I was really hoping scripts would be standalone at some point. Happy but also kinda disappointed. :(
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.