I am very new to this - I wrote a VBA project that was able to scrape and do everything I needed it to do a couple days ago, but with Chrome's update the other day, the project is now broken (getting an Automation Error on Set MyBrowser = New Selenium.ChromeDriver, reverting back to Andrew's code from the video). I deleted the old Chrome Driver and reinstalled the new driver matching the version of the new Chrome update figuring that would solve the problem, but still getting the same error code. Does anyone have any suggestions? Thanks in advance!

Excellent. You dont need any other videos. Enough for beginner to advanced.

Terima kasih.

I’m here in 2025. Thank you 🙏

In this videos, both you teach how to use and philosophy of work. This is priceless. You are teaching not just to usage but how to fishing.

After adding YearNumber column the dates in date column changed...starting from 1st Jan 2012 instead of 1st jan 2010

Hey Andrew, thanks for the video it is really simple and easy to understand even for beginners like me. I've been trying to access the links which you provided in the description for ACCESS and SQL Server Database. However its getting error, can you please check.

Can you create a Forms Quiz from an Excel spreadsheet? All I'm seeing online is automating the results, but never the creation of the Quiz itself. All done by hand like you did in the video

I was getting frustrated trying to figure out why my code with multiple JOINswasn’t working, and only now I understand why. Eu estava passando raiva tentando descobrir porque meu código com vários JOINs não estava funcionando e só agora entendi o porque

thank you so much so helpful!

Dear Sir Kindly guide. If we add multiple tables from an MS ACCESS database with relationships amongst them already defined in the MS ACCESS database itself to the Data Model, we have the option to import relationships by setting the particular argument = True. Now if we want to add multiple tables from an MS EXCEL WORKBOOK where those tables are already lying in Data Model in that MS EXCEL and relationships are also defined in that Data Model, can we import the relationships, too, just like we import them from an MS ACCESS database?

4:53 this deletes after i re-open the excel sheet every day. do u know why that could be?

Omg ty so much, after spend last 2 hours looking for information I find my code will need to include an offset🤦🏼‍♂️ Thanks again, and hello to a new sub :)

This is so helpful thank you!

Thanks

Hi. I want to copy a sheet from one workbook to another , while keeping the format using python. Would you know how to do that

Thank you for this whole series Andrew, invaluable stuff for someone learning the intricacies of PBIRB!

How can you repeat the footer row on each page?

what if i want to do an increase to a highlighted range of cells?

Could you provide db creation script since it is not available any more, please?

It still works in 2025, Thank you!

Can anyone explain the problem? The step where we insert a name of worksheet: * FROM [Sheet1$] - I get error when entering in [] the name of my sheet $bonds-12-2024. I tried all different ways but nothing works. I’m afraid someone may even suggest to change the name ($bonds-12-2024 ) of the sheet which will make it even more difficult!!(((

These tutorials are so helpful. Thanks for the explanation of the different ways to remove filters.

Thanks a lot for this and it was very informative.

How can I set profile in edge browser, whenever I run edge browser I get sign in Profile 1 issue how to handle it..Please suggest..

Sir, I want to know how to use a parameter to fuzzy match the content of a field. Lookup does not seem to support like, for example, 'A' matches 'A,B' instead of 'A,B' splitting and finding the right value.

Hi Andrew. Thank you for your great work. I have not been able to use Chrome profiles. When I open a new website with the Get instruction it always opens with a blank profile. I have tried all possible combinations but something that seems easy at first has not been possible for me. I have tried all the combinations: Dim wd As New Selenium.ChromeDriver or Dim wd As New WebDriver or Dim wd As New ChromeDriver 'I confirmed the folder location userProfile = "C:\Users\Me\AppData\Local\Google\Chrome\User Data" wd.AddArgument "--user-data-dir=" & userProfile or wd.SetProfile Environ("LOCALAPPDATA") & "\Google\Chrome\User Data" 'I confirmed the folder location and contents of each Preferences file wd.AddArgument "profile-directory=Default" wd.AddArgument "profile-directory=Profile 2" I have the latest version of Chromedriver and the Selenium Type Library option is enabled. I have never had any problems with Selenium. What can I try ???. Thank you again!!!

Thank you for demystifying the concepts of early and late binding. Much appreciated 😊

Thank you for a great explanation of the different variables.

Please, what is the trick to make a timetable for a school? Can we do it in VBA or we need a programming language like Python or others? Thank you

my english level is low, but i understood everything, thank you

Hey, it's been 5 months since you posted anything on your channel. Why not start the new year with M Language Videos !! ❤🎉

hi can i use these videos to learn Power Bi Report Builder (known as paginated reports) thank you!

🤜🤛 great tutorials

Hello, good morning, is it possible to contact you for a tutorial or to develop a requirement that I have at work?

Hello, In my report, I need to display the income statement report. This means I need to go through the indicators to take the general accounts that have a result, and then I look on the balance sheet screen for the parent of the result. There are 6 levels, meaning if the result retrieved from the indicators is among the code category 6, I need to retrieve all 5 parent categories. The same applies to all the general accounts. After that, I need to display them in a hierarchical form, grouping them with the categories. so I need help with setup in SSRS to properly display children in multiple hierarchy report. Can you help me. Thank you.

Hello - an excellent video, like all of the videos in your series. I have a question. Is there a way to transfer the results of a DASL filter to the Outlook Window? In the example code in this video, the DASL filter results are displayed in the Visual Basic Immediate window. What I am trying to do is display in Outlook the filtered set of e-mails resulting from the fol.Items.Restrict(filterString) action (in other words display the results from the VBA code in Outlook as if a search by "Subject Line" had been manually executed in Outlook itself). I have a macro button in an Excel Spreadsheet that when clicked initiates an Outlook Search by "Subject", utilizing a concatenated text string consisting of the phrase "RFP No." followed by the number value from Column A in the ActiveRow of the Spreadsheet (for example "RFP No. 8"). When using this text string as the Search string in the "Application.ActiveExplorer.Search" function in VBA, it does display the results in Outlook, but the results include not only the e-mails with subject line including the exact full text string phrase (for example "RFP No. 8), but also e-mails that include "RFP", "No.", or just the number itself (for example"8") as part of the subject line. IN other words the search results includes partial phrase matches. So it seems I need the "advanced search" capabilities of a DASL filter to be passed to Outlook so that only e-mails including the entire text string phrase as part of their subject line are displayed. Thanks very much. Jim

These tutorials are great! Thank you.

thanks

bad

Knowing how to change the properties of an existing relationship to be able to filter in both directions is so useful!

I feel like I'm going to be watching a new VBA video in 2025, and he'll be using this same 2012 list, and he'll be saying, "Let's put Gravity in the input box. I still haven't seen it; heard it's good. I'm planning on getting around to watching it."

hindi audio track ?

Pressing Alt while editing the button edges to align it with the cells was something I learned just today and it's amazing I've always wanted to do that! Just started this course and am already enjoying...

Amazing step-by-step and thorough video, Thank You!

Andrew, thanks for the very clear, understandable videos! I have a question though. In this case, the query extracted data from the source specified in the connection as well as other sources specified in the query itself. Let's say all you wanted to do was get data from the individual "Movies xxx.xlsx" files. This means there would be a connection to an unused data source meaning the connection source is not used at all. Is there any way to extract data from the individual xlsx files without specifying a connection? I tried and got an error.

best one

Harry Potter was the real hero but the video is very informative thanks

good