Unfortunately, there's no way in office 365 to do the same, which is unfortunate
@Dexter101xСағат бұрын
Just found it, its now "Excel Add-ins" rather than just Add-ins
@erendiz792 күн бұрын
Sir Andrew for what it is worth and if you can live with yourself and also sleep well with this idea, you should succeed sir David Attenborough, he is at a very respectable age, therefore i see a brilliant future ahead for you... You have probably the most excellent and clear British male voice i have ever heard. If people even can't program after watching your lectures, they will certainly learn some advanced level English.
@pk2k22 күн бұрын
Hi, do you have any idea why GetObject is not working? References are correctly charged. Thank you for your time!
@rjmc643 күн бұрын
I just wanted to say that I really appreciate your videos. They have been very helpful for me!
@sarikasingh45403 күн бұрын
How do I delete excel workbook on SharePoint folder?
@nationfirst-worldaffairs64104 күн бұрын
Plz free just dax tutorial unlock free ...I will Prayer for best wishes 🙏🙏
@sasifexcelsolutions45094 күн бұрын
You are truly the best, I can't think of anyone that does training the way you do, appreciated, is there any way we can get the excel files. Also can you make a video on undo, but not the application.undo one a real undo method similar to the normal way you undo in excel maybe attached to a button.
@other_stuffs-yj3dl4 күн бұрын
I completed the playlist! on to user forms :) thanks for the clear and free tutorial for vba. can't wait to use what i learned in my work
@salaiarunmanijb1744 күн бұрын
how to sort Month-YY in order
@salaiarunmanijb1744 күн бұрын
How to Sort MMM-YY(Month-YY) format in report builder.
@chaitanyajoshi6905 күн бұрын
Dear Sir Kindly guide: If I have to consolidate multiple sheets with same type of data but the column names differ across the sheets, can I first rename column names with the help of query itself and then use UNION to combine them? I know how to do it in Power Query, but pl. guide if and how it is possible with SQL/VBA query.
@WiseOwlTutorials4 күн бұрын
Hi! If you watch the video you can see that the column names can be different on each worksheet. As long as you select them in the correct order in each SELECT statement it will be fine. I hope it helps!
@Merirandomduniya5 күн бұрын
It's good, just that I want outlook to do it automatically instead of me clicking the run button every time. Is that possible?
@WiseOwlTutorials4 күн бұрын
You can! You can write event handlers to run code automatically when something happens in Outlook. Here's a starting point in Microsoft's documentation learn.microsoft.com/en-us/office/vba/outlook/concepts/getting-started/using-outlook-visual-basic-for-applications-to-respond-to-outlook-events
@user-sb5xv5nt6g6 күн бұрын
Truly an invaluable resource! You helped me with VBA at work now it’s time to learn this 🎉
@WiseOwlTutorials4 күн бұрын
Happy to hear that you've found our videos useful, thanks so much for watching!
@mohamedamro6 күн бұрын
Impressive as usual
@WiseOwlTutorials4 күн бұрын
Thanks!
@chaitanyajoshi6907 күн бұрын
Dear Sir Kindly guide whether the functions used in this series like IIF, IsNull, Switch, Format, Year, DateSerial etc. are native functions of SQL or Excel VBA. If they are functions from SQL , kindly suggest if there is any documentation regarding all the functions of SQL.
@WiseOwlTutorials4 күн бұрын
Hi! Annoyingly, they're neither Excel VBA nor SQL functions, rather a specific set of functions provided by the Jet database engine. See the excellent answer to this Stack Overflow post for links stackoverflow.com/questions/25226635/vba-function-in-excel-adodb-query
@MasterChelsea8 күн бұрын
Great video, sir! Thank you! Can anyone tell me please, how to OPEN the excel attachment in this case??? I can’t figure it out…((((
@shaikvalli14148 күн бұрын
9:50 Is it possbile to copy the data and add from multiple workbooks
@townnet8 күн бұрын
Hi, is possible to not have fix path in the Data Source? The reason is my source file is generated with different name and date every day. Is it got an option excel will ask you to browse the file after you click the button?
@HannaKandratsenka-v5t9 күн бұрын
I really appreciate the high quality and well-organized content of each session! The author put in a lot of effort to explain each aspect in a very detailed manner.
@WiseOwlTutorials8 күн бұрын
Thank you so much for the kind comments, happy to hear that you found it useful!
@NS-tp3vr9 күн бұрын
Can report builder downloaded for MAC? Or is there an alternate way to open .rdl file in mac?
@WiseOwlTutorials9 күн бұрын
Hi, I don't think that Report Builder is available in a Mac version.
@NS-tp3vr6 күн бұрын
@@WiseOwlTutorials ok. Is there any way to open report builder in mac?
@ericheng23819 күн бұрын
Hi, how to show empty value even if there is no data in Month Column? i.e. show all months including no data in December
@WiseOwlTutorials9 күн бұрын
Hi! You'll need to create some sort of date table that contains an entry for each month and combine this with your existing data. You can see some suggestions on how to do this here: stackoverflow.com/questions/45890909/ssrs-display-all-months-in-a-year-with-no-data stackoverflow.com/questions/44549413/ssrs-how-to-show-all-month-of-a-year-as-x-axis-of-a-graph
@noneyabeezwax88659 күн бұрын
YOU are amazing!
@WiseOwlTutorials9 күн бұрын
So are you! Thanks for watching!
@jhunnniemat444411 күн бұрын
hi, I have questions, why do we need to put exit sub? and when we will usally use it?
@WiseOwlTutorials9 күн бұрын
Hi, you can see a simple example in this video kzfaq.info/get/bejne/j717eNGIrMzIqYU.htmlfeature=shared I hope it helps!
@PadmajaJadhav-vd8cg11 күн бұрын
Best and perfect direct on the point 😊
@WiseOwlTutorials9 күн бұрын
Thanks for watching!
@konradstrozak996511 күн бұрын
Hello Andrew, Your videos are fantastic, love the passion in your voice. Actually i have one question and hope that you will help me even though this video is 2y old. But when i put in vba the formula ....FindElementByClass(...).Click i have a debug which says "Run - time error "32" : Invalid selector Error invalid selector From java script error {"status":32 " value : "Compund class names not permitted"} (sessio info: Microsoft Edge = 126.0.2592.87) Driver info: msedgedriver = 126.0.2592.87 and some random numbers and letters.platform=Windows. Do you know maybe hot to repair it ? Thank you for the help
@WiseOwlTutorials9 күн бұрын
Hi! You might find this video helpful kzfaq.info/get/bejne/othndqmLqq-WiXU.htmlfeature=shared I'm fairly certain I mention compound classes in there and it provides various other options for finding elements that you should find useful. I hope it helps!
@nelrosell111 күн бұрын
we can also do like this OR(ISBLANK(Movies[Box Office]),Movies[Budget]) as it's only two values are evaluated rather than using two pipes || for OR condition
@WiseOwlTutorials9 күн бұрын
Indeed you can! kzfaq.info/get/bejne/gbSkaLF6mtGlkps.htmlfeature=shared&t=1207 Although you need to include the ISBLANK function for Budget as well as for Box Office: OR( ISBLANK(Movies[Box Office]), ISBLANK(Movies[Budget]) ) Personally, I prefer pipes because they work regardless of how many conditions you're using, while OR only works for two conditions.
@MasterChelsea12 күн бұрын
Sir, thank you a lot for this great video!
@joaofilipecastrosantos994712 күн бұрын
You are a champion. You've produced all a student of Selenium VBA needs and you explain it all with great clarity. Thank you.👨🎓
@WiseOwlTutorials9 күн бұрын
Thank you so much!
@chrisf357713 күн бұрын
excel 2021 gives me an error when trying to Refresh the tables, do you have any solution?
@gideonglick580813 күн бұрын
how about if you want to sort multiple sheets, but the tables are not the same?
@treklin157315 күн бұрын
Very nice accent in teaching channel, I'm not a native speaker of english
@WiseOwlTutorials9 күн бұрын
Thanks for watching!
@DBJedi31716 күн бұрын
2 questions. 1. Can the add-in need to contain Sub procedures? 2. Does if require the Public (ie Public Function or Public Sub)? Thank you.
@WiseOwlTutorials9 күн бұрын
Hi! The add-in does not need to contain Sub procedures (but you can include them if you want to). If you want to use the functions in the worksheet they need to be public. If you don't declare a function as Private, it will be Public by default. I hope it helps!
@shubhamkupade700816 күн бұрын
if i want to see data without select pick start date and pick end date or not providing any default value for date is it Possible ?
@WiseOwlTutorials9 күн бұрын
Hi! Carry on watching the playlist and you'll get to the videos on optional parameters kzfaq.info/sun/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU&feature=shared I hope it helps!
@vishal_parajuli16 күн бұрын
How do you create that table folder, actually I am in the ODBS sys DSN connection were I cant able to see database overview etc on the query builder
@dushanshalina467617 күн бұрын
Xldown is taking all blank cells with formula. How can I correct that?
@other_stuffs-yj3dl17 күн бұрын
have to comment this haha. besides learning vba i love your movie reviews! haha
@WiseOwlTutorials9 күн бұрын
😀 glad you found them entertaining! Thanks for watching!
@charitomexico183018 күн бұрын
gracias!!!!!!! por fin solucione el problema con mis encabezados!!!
@WiseOwlTutorials9 күн бұрын
Happy to hear that the video helped you, thank you for watching!
@Trucpq18 күн бұрын
So helpful and excelent explanation !
@WiseOwlTutorials9 күн бұрын
Thanks! Glad you found it useful, thank you for watching!
@other_stuffs-yj3dl19 күн бұрын
Wow! As a starter with VBA I'm amazed haha. Thank you for this tutorials!
@WiseOwlTutorials19 күн бұрын
Happy to hear that you found it useful, thanks for watching!
@robertnpmk20 күн бұрын
So helpful, thank you.
@WiseOwlTutorials19 күн бұрын
You're welcome, thank you for watching!
@NilimaParbatani20 күн бұрын
this is by far the best series to give confidence to use DAX out of so many other videos i have watched. Great work Andrew!
@WiseOwlTutorials19 күн бұрын
Thanks so much! Happy to hear that you found it useful so far, thank you for watching and taking the time to comment!
@aindryarya20 күн бұрын
Hello!! Can you make a detailed video on how Helper queries work in power BI as well how parameters work in power bi
@MasterChelsea21 күн бұрын
Sir, your lectures are perfect!!!! THANK YOU SO MUCH!!!!
@WiseOwlTutorials19 күн бұрын
You're very welcome! Glad you like the videos, thanks for watching and for the comment!
@sourabhpatel383422 күн бұрын
Great❤
@WiseOwlTutorials19 күн бұрын
Thanks!
@likhitaGrandhi23 күн бұрын
Hi, Thank you for your amazing tutorials, they are very clear. It has helped me developing many reports and improve my skills. I have question, Can you please explain how to pass a user defined table type to SP in Report builder? I would really be Grateful if you can help me. Thanks.
@WiseOwlTutorials19 күн бұрын
Hi! Happy to hear that you enjoy the tutorials. Sorry but I don't know how you'd pass a user-defined table type from Report Builder to a stored procedure.
@voiceless889325 күн бұрын
I am sorry there no "Join" button at the bottom of any video?
@WiseOwlTutorials24 күн бұрын
Hi! It could be that channel memberships aren't yet supported in your region: support.google.com/youtube/answer/7636690?hl=en
@ArchStanton80625 күн бұрын
Hi Andrew, can you help me with the following please? Case Complexity 1 = CALCULATE( COUNT('Cases'[Case Number]), DATESYTD('Cases'[Resolution Date],"3-31"), 'Cases'[statecode] = "Resolved", 'OS Case Complexity'[Value] = 1) I'm getting this error message and no matter what I try I can't fix thing: Couldn't load data for this visual MdxScript(Model) (320, 5) Calculation error in measure 'New KPI Measures'[Case Complexity 1]: DAX comparison operators do not support comparing values of type Text with values of integer. Consider using the Value or Format function to convert one of the values
@WiseOwlTutorials24 күн бұрын
Hi! Without seeing your data model I would guess the problem lies with this part: 'OS Case Complexity'[Value] = 1 I'm guessing that the [Value] field is stored as text rather than a number. You could either change the data type of the column in the data model, or enter the number as a string like so: 'OS Case Complexity'[Value] = "1" Let me know if that helps!
@ArchStanton80624 күн бұрын
@@WiseOwlTutorials Thanks, I've modified the value so its now Text and it works. Much appreciated
@WiseOwlTutorials24 күн бұрын
@@ArchStanton806 No problem, happy you got it working!