Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
@AWFarmer
3 жыл бұрын
New VBA macros have never been so well commented when recording. Office script doesn't look bad.
@chetanbangadi1686
3 жыл бұрын
Dear Leila, Good afternoon, Your teaching style is very simple and easy to understand. Thanks
@dlep9221
3 жыл бұрын
I hope that the office script language will be quickly included in Excel Desktop to have the same level of functionalities everywhere.
@LeilaGharani
3 жыл бұрын
I hope so too.
@timolff9239
3 жыл бұрын
I can imagine that they may not do so in order to fit into a longer term strategy to eventually make excel web the primary version of excel rather than the desktop verison. It would make sense among the strategies from the big tech players. Even if it doesn't add value for a long time for many users, it certainly adds value in the area of data storage. Offline business process means that you're duplicating large files many many times while you're emailing or otherwise sharing it. And while digitalization keeps advancing as it does then the cost of this storage will certainly add up to amounts that may not be feasible. Now i don't have enough knowledge to say whether these costs relate directly to how many GB's are on servers or whether it's more complex but i know that the costs are definitely there.
@aruneshbahadur742
3 жыл бұрын
Do you think this would be the death of VBA
@fabiospringer6328
3 жыл бұрын
@@timolff9239 Microsoft sells Office 365 for local servers? If not most big companies will not use excel online.
@souzamotasacul
Жыл бұрын
Now they have
@ramm4012
3 жыл бұрын
GREAT Teacher. Kudos. Thank you Leila. I have allways viewed your videos and learned. You make a difference. With Gratitude
@SimpleExcelVBA
Жыл бұрын
Really nice & short example of Office Script. Appreciate your work!
@vijayarjunwadkar
3 жыл бұрын
Nice video to get started on Office Script! You are a great teacher Leila, taking one step by step through the procedure, while explaining it so well! Appreciated and looking forward for more! 😊👍
@LeilaGharani
3 жыл бұрын
Thank you so much!
@JuanMartinez-ic3sg
3 жыл бұрын
Great video. I hope you continue this series of videos about Office Scripts.
@andrewmoss6449
3 жыл бұрын
It will be really cool when Office Scripts comes to the desktop version. I’d also like the ability to manipulate dropdowns, checkboxes and radio buttons - just like with VBA.
@LeilaGharani
3 жыл бұрын
Agree. It would be great to have more functionality.
@johnfromireland7551
3 жыл бұрын
@@LeilaGharani The button control is being testing, currently.
@themen012
3 жыл бұрын
Honestly (in my opinion) you became an advertiser more than a teacher.
@igenart
3 жыл бұрын
Honestly too (in my opinion): I don't think so. This happens not to often in youtube, that the actor is precise, fast and correct. I understand some words included as a hint to commercial training.
@hospitaldecisionsupport3497
3 ай бұрын
Hi Leila, Thanks for your nice and easy to understand videos. I have a relatively simple project that I want to do in office scripts. Here's the project: There are 16 files in a folder like 1, 2, 3, 4...16. Each file has 5 worksheets with similar names like a, b, c, d, e. The task is to summarize all these files. I need to copy cell 'B2", 'B3' and 'C2:F2' from all files' x worksheets and paste those into a file name Summary's worksheet 'summary' cell B1, B2, 'B3:F3' respectively. All copied cells will be pasted one after another in the summary file. I can run manually without any auto trigger as it is required to do occasionally. The objective is to avoid copy paste manually which is error prone. How can I achieve this? Thanks, Ash
@selfmadetool
3 жыл бұрын
Thank you for taking the time to record this!!
@LeilaGharani
3 жыл бұрын
My pleasure!
@FarhanMerchant
3 жыл бұрын
I like this approach, need to test it.
@nonoobott8602
3 жыл бұрын
Great stuff. Your videos are always so informative and insightful. I've become way more productive on my job. Thanks for your awesome videos
@KevinChar
3 жыл бұрын
Hey Leila, I have attended your VBA course for Excel last time. That can't overstate how great your course is. I still use it to this day and I still go back to the course from time to time for what you've taught me. Yes, I honestly feel the need to have the VBA power on the web. If you are planning to have Office Scripts course, I will definitely be the first student in your class!
@LeilaGharani
3 жыл бұрын
You made my day :) I'm glad you found the VBA course useful. Thank you for sharing.
@hasnainakram1530
3 жыл бұрын
I also took the VBA course on udemy. Great teacher. God bless you 🙂
@gabrieleminniti7031
3 жыл бұрын
Leila, you are my hero!!! Thanks a lot!
@SampsonBert
2 күн бұрын
when you say dynamic what do you mean?
@ewoudnl
6 ай бұрын
Any idea how to start an Office Script from the Quick Access Ribbon?
@birasafabrice
Жыл бұрын
this is a great tutorial, thanks!
@manabisrael
Ай бұрын
Hi Leila, is it possible to use paste special function in office script - I want to paste only values - do not want to copy formulas. For example - I want to copy ranges A1:D4 , which has formula - now I want to paste the value only in the range K10-O14.
@SyedMuzammilMahasanShahi
3 жыл бұрын
Brilliant work. Thanks for the share.
@LeilaGharani
3 жыл бұрын
Thank you! Cheers!
@I.A.S.
3 жыл бұрын
Thank you.
@GloriaSun-m8t
Ай бұрын
How to use office script to save excel as PDF with ExportAsFixedFormat with friendly UI.
@MostafaEhab122
3 жыл бұрын
Really helpful, thank you a million!
@LeilaGharani
3 жыл бұрын
You're welcome!
@anwarkrg9292
8 ай бұрын
Hi Leila, I am currently learning office script and found your postings are really helpfull and easy to understand. I would like to ask a question, I want to do vlookup the data from the active file by opening another excel file. How to put this step in the scrip without using power automate? Would appreciate your help on this.
@garynagle3093
3 жыл бұрын
Great video. Very useful!
@LeilaGharani
3 жыл бұрын
Thanks, Gary!
@ALIRTHCN
3 жыл бұрын
سابسکرایب کردم چون همیشه به ایرانی هایی که باعث افتخار کشورشان هستند افتخار می کنم.
@remars-xcel
3 жыл бұрын
Hi Leila saw your ad for a job , just wondering if you guys take apprentice. I just love to learn and I help other people through excel. Take care
@mars2459
11 ай бұрын
nice. not sure if this was already covered but what if you have vlookups, sums, and other formula how do you make that dynamic when you have varying lines for different worksheets when using automate
@OVERALLFITNESSGALLERY
11 ай бұрын
thank you
@AngeVPV
3 жыл бұрын
Great video!
@yongkyosunim
3 жыл бұрын
Is Office Scripts good for clicking on links in Excel getting a document that will display as pdf and then save that pdf to a drive?
@vssuresh
3 жыл бұрын
Wonderful tutorial Leila..👏👏👍 but unfortunately i don't have the Automate function activated 😌
@soheehan9180
2 жыл бұрын
Can you make a button and assign one of the script
@jfamtd2770
Жыл бұрын
Unfortunately I don't have the "Record Actions" button available. Our organization uses the installed App. So while we can run scripts, and manually create a script, we can't record them. Do you know if this functionality will come to the installed apps?
@TerreneTaylor
11 ай бұрын
Could you create a shortcut to run the script ? I know in old versions you could
@internationalpolitics1275
Жыл бұрын
Hey Leila 'Record action' option not available in my excel automate group. Any help on this
@eugrus
Жыл бұрын
There is no "Automate" ribbon on Word's toolbar. How do I access the Office Script environment from Word's UI?
@thepotbellyninja
Жыл бұрын
I have the 'Automate', but I do not have the 'Record' button . . . only 'New Script' . . . is it disabled?
@GenNextAnalyst
2 жыл бұрын
Hey Leila, when are you going to have more videos on Office Scripts?
@Explore_Your_Choice
3 жыл бұрын
Please make video how to fix no internet access in windows 10 while globe sign appears.
@chrissmith5347
Жыл бұрын
Hello Leila, I am new to office scripts and am trying to work out how i run a script that clears all filters and automatically finds the next available row in an excel table and to run this automatically when the excel file is opened in the browser or teams is this possible with excel scripts? Thank you for your time.
@manabisrael
Жыл бұрын
Hi Leila, Can you please do a video showing office script to select an empty cell in a sheet and past value to it from another sheet? For example - suppose in sheet 2, I have some values in column A up to row 10, i.e., A1-A10 full. Then I need to copy and past more data from A11 and I want to keep A11 as dynamic.
@KianBoon
3 жыл бұрын
Is it possible to refresh power query using office script? I don't seem to be able to do that.
@KaiWeissmann
3 жыл бұрын
I would be interested in that as well :)
@Interesting-AF
3 жыл бұрын
no =(
@edgards
3 жыл бұрын
This is great! Do you have any videos how to attach these charts in an email?
@dmstar101
Жыл бұрын
Hi Leila, love your videos and have revisited them several times to clarify Scripts and automate functionality. I need assistance with a script. I have 2 tables. one is a master contact list and the other list customers NOT to be contacted. I have used an xlookup to identify the customers in the master list that need to be removed and when recording the script, and I filter the column to list the customer's to be deleted (then delete all rows to be left with the rest which are the #N/A) the script lists the customers. How do I point this "getvaluesfilter to the table so it is dynamic as we may add more customers to be excluded table?
@ThisIsScorefun
2 жыл бұрын
Great tutorial, thanks. just for understanding: There are semicolons at the end of each generated code-line, but in your new inserted lines at 9:38 you haven't add them. Therefore not necessary?
@kahhengyeong7947
3 жыл бұрын
Nice but regarding the dynamic range, in the offline Excel macro, I can do that by recording with "Ctrl-Shift-Down". I tried on the Office Scripts but it doesn't work. Hopefully "Ctrl-Shift-Down" can work in the future.
@LeilaGharani
3 жыл бұрын
Yes - it doesn't pickup the region - at least not yet.
@johnfromireland7551
3 жыл бұрын
Here is some example the code for that : selectedSheet.getRange("a2").getExtendedRange(ExcelScript.KeyboardDirection.right).select() selectedSheet.getRange("a2").getExtendedRange(ExcelScript.KeyboardDirection.down).select() I can't, currently, see how to select a 2D shape ( not one row or one column as above) using the getExtendedRange method.
@kgomotsomogashoa8870
Жыл бұрын
My Excel does not have the "record script" option
@ai_dividend_daily_1
3 жыл бұрын
nice
@wayneedmondson1065
3 жыл бұрын
Hi Leila. Looks awesome! You make it seem so easy. Unfortunately, I don't have access to the Automate tab. Is there any way to gain access to Office Scripts if you don't have a business or enterprise account? If Microsoft wants to gain a following for Office Scripts, they should give early adopters access now.. like through the Beta Channel or via online with a personal account.. for those who are interested in experimenting. Hope that happens soon! Thanks for the look at what is to come in the future :)) Thumbs up!!
@LeilaGharani
3 жыл бұрын
This is a good point. Google Apps Script is also available for all and not to business users only, so I hope they change this soon.
@taizoondean689
3 жыл бұрын
Thanks
@hugarohugaro
2 жыл бұрын
Hi Leila, is it possible to use office scripts across multiple workbooks? For example, doing Xlookup across multiple workbooks so can eventually connect it with Power Automate
@omernozi
Жыл бұрын
Hello, my MS Office opened in google chrome, how can I stopped it
@ManojKumar-zn2gf
11 ай бұрын
Out of curiosity, is it possible to have a single office script that can run on two different workbooks with has same information ie. simply it has to create a unique ID in both scripts. Instead of having two scripts in two workbooks, I should have only one script that can create an id on both worksheets.
@LeilaGharani
11 ай бұрын
That's the beauty of Office scripts. They're not stored in the workbook but in your OneDrive. So, you can use the same script in any of your workbooks.
@hariharan.C
3 жыл бұрын
In my laptop whenever i click or enter control panel or any other things on which there is a white background screen brightness increases and whenever i switch to dark background, brightness decreases what the solution for this??
@Felipe_XIV-XVI
3 жыл бұрын
What about UserForms? I've developed a mini app using Excel, but I understand that VBA is old & actually I should try, if I want to keep my "program" to migrate to an actual code, like Python or so.
@anthonyaltman4021
2 жыл бұрын
Leila, can you simply export a sheet to csv using office scriptS
@KayDee2021
3 жыл бұрын
I am sorry if this post is irrelevant to the video above. I just somehow wanted an answer. The problem in Excel is i have two columns of data worth 3000 rows. All are text. Lets say there is a text 'military personnel' in one cell and there is military in the other cell just below or above it. I want to highlight military as it is repeated in one of the cells. There are multiple instances like this in the entire table, not just military but similar instances, but i am unable to get the desired results from Conditional Formatting or Search Fn or Find Fn. I want Excel to crosscheck duplicates in multiple words aswell where the words become part of two or three or four words. Can you help?
@svendb7
Жыл бұрын
Dax, m code, office scripts…my head spins
@RobertLoPinto
3 жыл бұрын
Can you view the list of script names in one vertical column? The horizontal layout at the top barely fits the names of the 3 scripts. What does it look like when you select the drop-down arrow? What if there were hundreds - how to search, browse and organize them all?
@johnfromireland7551
3 жыл бұрын
Click the All Scripts button in the menu bar (aka tab). You can also view the actual Scripts in your OneDrive. They appear as osts files!!
@PeymanSayyadi
3 жыл бұрын
Great Video. Can we use the Officescript to manipulate files and folders in OneDrive?
@johnfromireland7551
3 жыл бұрын
Office Scripts object model is only Excel Online - not the OneDrive object model. Use Power Automate for that.
@stopwhininggente
Жыл бұрын
SUPER complicated
@reng7777
3 жыл бұрын
Leila i got a question.. i do have an office 365 account but is not for business instead it is personal, how ever i got installed the Add_ in ScripLab tool , wihch is the same for AUTOMATE option that you have , but for some reason is not working when i mimick the same exanple that you have provided to us in this video!! What would you say would be the reasons?
@LeilaGharani
3 жыл бұрын
As far as I'm aware Office Scripts currently don't work for personal account. You could however, post this on the Microsoft Tech community for Excel- maybe someone can provide more insight.
@fatjanpaloja9182
3 жыл бұрын
Hi Can script be assigned to button, like macros ?
@LeilaGharani
3 жыл бұрын
Unfortunately, not yet.
@marcoromero199
3 жыл бұрын
The salary of the accountant made me cry.
@haydeecastillo4621
3 жыл бұрын
Financial analyst 😭
@chh8860
3 жыл бұрын
" ... VBA Macros don't work on the web ... and they don't work in Teams ...". I have a number of financial models that use VBA macros, Form Controls or Active X (created in desktop Excel) that I intend to move to SharePoint ... and hopefully provide access by others to either use and/or view. (FYI ... so far for me, the jury is still 'out' on Teams ... constant problems ... not reliable enough ... too many messages "Sorry, we ran into a problem" ... prefer to stick with a customized SPoint site) Three questions please: 1) Do VBA macros work in SharePoint? ... or should those models also be changed to Office Script? 2) Can Office Script use Form Controls? ... or ... ActiveX? 2) My impression is Excel on the Web does not have the same functionality as Excel Desktop. Correct? 3) Do you have a suggestion where I can go to see the differences between Excel Desktop and Excel on the Web? PS At the 10 min mark: "Okay ... so far so good ...". I wish I could say that. For me it's frequently; " Okay ... so far what a mess ... ". Thank you ... thank you ... thank you ... you are simply the BEST!
@LeilaGharani
3 жыл бұрын
Hi - I had to laugh for the 10 min mark comment 😁. Regarding your questions: 1. It depends. If you have synced the SharePoint directory to your own drive and you open the file with Excel Desktop (Like I usually do), then they will work. If you open the files directly with Excel on the Web, then they will not work. 2. No. At least not yet. 3. Microsoft is working on improving Excel Online. Here's a video regarding the differences: kzitem.info/news/bejne/0W982oCKfKt3nGU
@chh8860
3 жыл бұрын
@@LeilaGharani Thank you ... Thank you ... Thank you ... always so helpful.
@johnfromireland7551
3 жыл бұрын
2. The button control is being tested, by the Office Scripts team, currently.
@homejonny9326
3 жыл бұрын
Is it possible doing this in the free version?
@LeilaGharani
3 жыл бұрын
No, unfortunately, not.
@homejonny9326
3 жыл бұрын
@@LeilaGharani thanks :)
@hichamzima1414
3 жыл бұрын
How can I install Microsoft Office365 for free.
@LeilaGharani
3 жыл бұрын
kzitem.info/news/bejne/0W982oCKfKt3nGU but this feature is in the business version for new.
@ericxls93
3 жыл бұрын
Don’t really understand why Microsoft would change VBA language... makes our lives harder! Then as long as MS keeps such complexity to get external data I don’t see myself using this any time soon...
@nikeshnadesan9318
3 жыл бұрын
Hi madam please explain how to migrate mail from Gmail to office 365
@64210187
5 ай бұрын
Its kinda boring. It is about actions/steps that really dont take much time to perform normally. Its just a simple table. Now if you tell me how to merge different excel sheets and pre-clean those files and mix/scipt together with a spooled file fom 4 to 6 times a day (like i do ) then yes, it is important. But that is not shown here.
@ratnoinamaew7822
3 жыл бұрын
Dear Leila, any chance of you doing a video in an Excel coloured 2 piece bikini? I think it would help a lot.
@mdcs1992
3 жыл бұрын
Oops sorry. Misread as How to Twerk.
@LeilaGharani
3 жыл бұрын
😁
@szisziszilvi
3 жыл бұрын
hi, nice video, I'd love scripting, though things seem to be buggy. I've tried to follow the video and my code sometimes creates new series for each data row, sometimes works well and takes them as one. I could not find a logic when it goes wrong and when it won't. I've created a recording of the bug, happy to share if that helps. I reduced the code to just create the chart, so what remained: function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); let myrange = selectedSheet.getRange("A3").getSurroundingRegion().getAddress(); let chart_1 = selectedSheet.addChart(ExcelScript.ChartType.columnClustered, selectedSheet.getRange(myrange)); }
@johnfromireland7551
3 жыл бұрын
What is the bug message? Put it here. Describe it?
@szisziszilvi
3 жыл бұрын
@@johnfromireland7551 I don't have a bug message, things just go wrong. I click on run once, and things are fine. I click on Run again, and boom, I have multiple series. Here is a screen capture as unlisted video: kzitem.info/news/bejne/lqGf1pN8gYadg6Q
@ricos1497
3 жыл бұрын
@@szisziszilvi Did you ever work this one out? Looking at your code, I'm guessing it's because the "ChartSeriesBy" option isn't explicitly set (or is using the default). I've not tried it, but I'm guessing you could create the chart and then a line that to set data: chart_1.setData(myrange, "Columns"); I don't use office online, so I can't test, but may be worth a try if you're still struggling with it.
@szisziszilvi
3 жыл бұрын
@@ricos1497 hm, thanks for the tip, I'll try. Though I got the code simply by the recorder. Also it is not clear to me why sometimes it works and at the next run (without changing anything) it fails.
@ricos1497
3 жыл бұрын
@@szisziszilvi I'm guessing because if you don't specify the series type, Excel "guesses" the series type, which could result in a different answer each time. If you explicitly include it in the code that should be overcome. Another check you might want to do is to write the range address to the console (see Leila's video for this), just incase the current region includes other cells that are confusing Excel. For example, it might be expressing the range address as A3:B8,A9:B9 as opposed to just A3:A9 or something else that will trick Excel into defaulting to series rows.
@gc2603
3 жыл бұрын
Hey Leila, is there any way to ignore events/prompts/display allerts with script (like in VBA)? What i mean - i made a very simple script - refresh all data connections (Analyze in Excel file for Power BI), and script works fine but data doesn't update. I think the problem is that prompt window when i do manually refresh by clicking "Refresh All data connections" button in Data tab and there appear mentioned prompt abou Conection Safety (i have to click Agree/ok to run refreshing), and i think script doesn't "see" it so it just cancel refreshing... In few words: Run script (pivot tables refresh) and it runs, but pivot tables doesn't start, nothing happens. any idea?
@Interesting-AF
3 жыл бұрын
unfortunately refresh all connections doesn't work in Office Script (like it does in VBA)... typical Microsoft, releasing stuff half baked
@gc2603
3 жыл бұрын
@@Interesting-AF i cant like your answer... got same oppinion like yours ;) i hoped that this feature will work, and i'm quite piss*ed off. This feature could be a little game changer, for now it isn't.
@Excel-power-users
3 жыл бұрын
Can we run power query with office scripts
@timotheospetros
3 жыл бұрын
Presumably Office Scripts are not available to those with Office 2019 rather than the rented version called Office 365.
@LeilaGharani
3 жыл бұрын
Only on the Excel web for now (Business / Enterprise versions).
@joellen8255
3 жыл бұрын
Your video is easy to follow and a great jumping off point for me, as I'm new to Excel for web and spent ages trying to figure out how to workaround lack of macro and VBA support. Then I found the magic words 'Office Scripts'. Thank you very much!
@LeilaGharani
3 жыл бұрын
Glad it was helpful!
@estivisonmc
3 жыл бұрын
Cool! It's future VBA on web office
@EthanJohns-j2k
8 ай бұрын
Hello Ma'am I'm really impressed by your videos Actually I'll have to present my topic in front of my university class So, I need your help. if happy to help me in using Automate Tab
@danbromberg
3 жыл бұрын
I have OFFICE 2016 PRO but don't see an AUTOMATE option. Does it exist for us home users in OFFICE 2016?
@chrism9037
3 жыл бұрын
Super helpful, thanks Leila!!
@darshitrander2741
3 жыл бұрын
It's Helpful and Amazing, Thank You So much, It helped a lot!! 2nd Viewer 2nd Comment
@LeilaGharani
3 жыл бұрын
Thank you! Cheers!
@arnauddrouin1426
5 ай бұрын
Great video thanks a lot ! I have a question : If I already have my formatting, my chart, and other functions on my sheet, and I want to duplicate this formatting onto other sheets in my workbook, do I have to start from scratch by recording my actions? Is there a solution for sheets that have already been created?
@sudhirsundararajan6613
2 жыл бұрын
Can a repeative vlookup be automated using office script?
@tpeiNNN
2 жыл бұрын
can u make a tutorial on how can i give permision on users who can edit my worksheet per selected cell range like in google sheet you can select and restrict users what cells they can edit and cannot. thanks in advance
@AutoOneWork
2 жыл бұрын
How to get the value of merged cell which is not is first one in merge range by office script?
@GameboyMufti
Жыл бұрын
Do you have any course to offer for office scripts. Thanks
@Stef1955
2 жыл бұрын
I was hoping to be able to do subtotals, but I don’t think it is possible.
@ramymahfouz1494
11 ай бұрын
Thank you for this fantastic video. it was helpful. This gave me a fair idea about Office script future. I want to ask if you have prepared a complete course on this so I can buy it.
@LeilaGharani
11 ай бұрын
Glad you liked it. Unfortunately, no course yet.
@tedescojunior
Жыл бұрын
Hello Leila, nice video and example. Is it possible to run a PowerShell or Bat file from the Office Script? I am trying to do but I can't to see how to and the documentation of Office Script there's no any information about it =(
@MariaSaleem-gi4uj
6 ай бұрын
Very helpful....
@ramanmahapatra1514
2 жыл бұрын
Hi, Leila. Is there a way in the office Excel script to generate XML and write it to file? In Excel running on Windows, we can use MSXML to read and write XML by using VBA. Do we have something similar for Excel 365 running on Mac?
@alihamiad7849
3 жыл бұрын
Doest the script work on non online Excel spreadsheet?
@johnfromireland7551
3 жыл бұрын
No.
@internationalpolitics1275
Жыл бұрын
'Record action' option not available in my excel automate group. Any help
@MrLuuHai
Жыл бұрын
Your problem is the same mine, even I 've using CopuRight Office 365 Version.
@internationalpolitics1275
Жыл бұрын
@@MrLuuHai mine is resolved now, Open excel in browser then record action will appear
@juanpablohorn6642
Жыл бұрын
Im not sure if there are further videos on the subject, but i would like to see how this has changed since last year! Maybe there are more posibilities.
@swaminathannarayanan2639
3 жыл бұрын
I'm eagerly waiting for your full course about office script same like power query. Is it possible?
@haowang6005
2 жыл бұрын
Great to know stuff about office scripts! Hope can develop custom functions and share within teams across the web!
@yulanari1914
3 жыл бұрын
Leila, thanks for sharing this truly informative learning. Would it possible to have Office Timeline? Thanks
Пікірлер: 192