VIDEOS BY CATEGORY▼
- VIDEOS HOME PAGE
- .NET (14)
- Business Intelligence (40)
- Integration Services (19)
- Macros and Programming (81)
- Microsoft Excel (63)
- Microsoft Office (85)
- Miscellaneous (1)
- Power BI (32)
- Python (29)
- Report Builder (106)
- Reporting Services (112)
- SQL (42)
- Visual Basic for Applications (212)
- Visual C# (14)
VIDEOS BY AUTHOR▼
Wise Owl: Microsoft computer training videos
We've published 500 training videos, helping you to understand Excel, Power BI, SQL, VBA, C#, SSRS, SSIS and Report Builder. Click on one of the categories on the left above for a list of the video goodness available for viewing (and all anonymously and free of charge!).
Your YouTube videos already have tens of thousands of compliments, but I want to add that you are not only the best VBA or coding instructor, but simply the best teacher of ANY kind that I have ever seen. (I'm fifty and have 2 degrees.) The fact that you make this content freely availalble is mind boggling. Your videos have taken me from basically no coding experience to writing very complicated business-critical applications... and actually knowing 99% of what the code is doing. (It has also taken hundreds of hours of my life and wasted a year's worth of Netflix subscribtions!)
Your older videos on web scraping and the recent series on Selenium have been especially useful to me recently. I have a specific need to regularly synchronise / ftp a local folder/files to a web server and can't really find anything useful or recent on the topic. It appears that WinSCP (see https://winscp.net/eng/docs/library_vb) offers a useful dll that will allow extensive control of this. They also offer some VBA code examples on how to implement it...but, unfortunately, it is still a step too far for me.
I realise you must have a long list of topics, but perhaps control of this function / dll will be useful to many. There really is no other content around about this.
Thank you so much for the kind words! It's very rewarding to hear that the videos have helped people so thank you for taking the time to write down your thoughts, it's very much appreciated.
You're correct about the long list of topics - it only ever seems to grow! I'll freely admit that I'm not an expert in FTP using VBA but this topic has been on the list for some time already. I'm reasonably certain that it's possible to do this using some Windows API functions rather than third-party software (although WinSCP does look pretty helpful after a brief look).
I'll try to find time to get something working - no promises though!
I'm very impressed with your teaching style. I want to learn these below topics from you. Can you please upload 2 videos on these topics?
001) How to auto fill Web Form using Excel Worksheet Data through VBA? Once it fills up the entire Form, the Submit Button (in Web Form) will be clicked automatically to store the Data in Server. And, then proceed to the next Row of Excel Data. This is how the entire procedure goes on till it reaches the Last Cell in Worksheet.
002) How to convert Word to PDF, PDF to Word or Excel to PDF and PDF to Excel using VBA?
Hi there, we do already have a video on saving an Excel workbook as a PDF which you can see here https://www.wiseowl.co.uk/vba-macros/videos/vba-files-folders/save-as-pdf/
The technique for Word is essentially the same, using the ExportAsFixedFormat method.
It's unlikely that I'll create a video to answer your first question but we do have videos on the individual techniques you'll need to make this work. We have a whole section of our online training course devoted to looping through collections https://www.wiseowl.co.uk/online-training/excel-vba/collections-for-each/
We also have several videos which describe how to work with websites using VBA https://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/
All you have to do is put it all together! I hope that helps and thank you for your comments!
Thank you Andrew, You've always been my inspiration. What you've been doing for Human, cannot be expressed in words. After learn VBA, I wish to go for Python and Oracle to boost up my career. Because, in our country India, these 2 languages are in demand most for Data Analysis. Hope, you'll uploading videos on these 2 languages on YouTube in near future.
On behalf of Andrew, who is temporarily furloughed, thank you! I don't think we will ever do Oracle, but Python is a good possibility.
Andrew, I did not go to school for any type of coding. I was previously an account support agent taking phone calls. One day I ran across your videos online and several hours later (due to binge watching) I found myself writing my first bits of code. I rewatch bits of your videos on a weekly basis to refresh in parts here and there. Because of wise owl I am now employed as a business analyst with the same company, my primary role is to automate work that deals with spreadsheets of data and connect over to our SAP system. Wise Owl VBA videos have taken me to where I am now and I have nothing but the highest praise for the work you have done making them. I enjoy my job a great deal, I love to hear how excited people get when I tell them I can automate a task that they are doing manually. I also enjoy playing around with VBA to create things like, my own version of Yatzee with dice you can roll. I cannot thank you enough.
I would like to thank you all for wonderful job you have done.
I am 54 years old and I'm from Moscow. I started to learn VBA a few month ago and realized that it's almost impossible to find fine courses for VBA in Russia and on areas of the World Wide Web. Fortunately I've found your web-site and what can i say - you are brilliant.
Special thank to Andrew Gould. He is my hero from now.
Thank you all!!!
I saw and watched the videos of Andrew Gould about VBA. At first, i just wanna try few samples as I am discouraged watching videos I can't follow. But his videos were...top of the line. Everything is clear and most possible scenario that you might encounter like mistakes you might do or errors you might encounter were explained in advance.
I can't help myself watching the next video so I am here having no strength watching for almost 4 hours straight.
This is all Andrew's fault!
This is the best video series I have ever seen in any tutorial videos. The explanations were clear, a little fast but excellent voice. Really happy I saw his video tutorials. Too bad I am on the other side so can't join at least one of your site trainings. A thousand likes to your video tutorials.
I have seen a few of Andrew Gould's VBA training videos online and feel compelled to congratulate him (and I'm sure there are other contributors too) for such an excellent piece of work. I am due to fly out next week to Mauritius for my annual long break and this year it will be spectacularly good, lying on the beach, whilst trying to teach myself VBA .... not sure if I want to thank Andrew for this !!! But on a positive note, this is the best training videos I have seen for a long time. Keep up the good work. I will spend more time looking at your website to see what else you all do and more importantly to spread the good word about you guys. Cheers. Azeddine
Thanks so much for your tutorials. It shaped my knowledge on excel vba. I would like to know if any chance to create tutorials on creating DLL files & using it in VBA macros, will be very useful for our community. I see there are no good training materials available on tihs topic.
Hi, I'm happy to hear that you've found the tutorials so useful. As to the topic you've suggested, it's not possible to use VBA to create a DLL so you'd need to learn another language in order to do this, perhaps VB or C#. You can find quite a few resources on this topic already - here's the first link Google returned to me http://www.geeksengine.com/article/create-dll.html
I hope that helps!
I'm very much impressed by Mr.Andrew Gould .He is indeed the best teacher (with very calm voice and amazingly impressive teaching skills) iIve ever come across. He is very engaging and the way he teaches us (whether its SSRS,SQL or SSIS) is very learnable. I thank Wise Owlfor making efforts like these for people they actually don't know..Unknowingly theyre helping people to get a decent livelihood irrespective of their nationality,religion or race.Thank you!