Automation Made Easy

Automation Made Easy

Hello Friends, Welcome to my channel, here we will learn how to automate routine data tasks. We will use simple automation techniques on excel and Google sheets to increase efficiency and accuracy in our mundane time consuming repetitive tasks.

# Automate Data Entry on Web Applications Using excel macros
# Automate Data Entry on Chrome & Edge browsers Using excel macros
# Google Sheet Macros
# Automation Google App Scripting
# Automation using Selenium

Пікірлер

  • @arthviraj5132
    @arthviraj5132Күн бұрын

    Need help, If the browser version gets updated in the system, We have to update the same in Selenium Basic, Is it possible to get auto-updated in selenium basic

  • @angechaplin8721
    @angechaplin87216 күн бұрын

    Thank you sir !

  • @AutomationMadeEasy
    @AutomationMadeEasy4 күн бұрын

    Most welcome!

  • @soniyagowda9771
    @soniyagowda97718 күн бұрын

    From where i can find the script

  • @AhmedHassan-s9o
    @AhmedHassan-s9o10 күн бұрын

    When I enter the script into Google Sheet, I get an error message The data does not appear completely in the data sheet Just one row

  • @Amit-q5c
    @Amit-q5c14 күн бұрын

    How to make it dynamic for multiple employee to send for their data individually. Where each employee keeps more than 5 records data to be shared

  • @anuragdey3455
    @anuragdey345514 күн бұрын

    Your video is useful .In this video you help to populate text on homepage text box of Facebook, I have a scenario where the home page is login page and data entry is done on second page after login. So through this process I am unable to solve my purpose.I subscribed your channel and eagerly waiting for video .

  • @angeladefranco5459
    @angeladefranco545915 күн бұрын

    Thank you for this --- very helpful. One question - can you add a notes column only to the excel file and will any notes you add stay with their respective rows once you refresh? I like using google forms to collect data, but I would prefer the data to go directly to Excel where the formatting is easier. I do not want to use a product like Zapier, have to add coding, or depend on manually downloading anything. So I'm hopeful I will be able to add information in both google forms and Excel, and have the google sheets just sit there in the background to shuttle info over to Excel.

  • @anuragdey3455
    @anuragdey345516 күн бұрын

    Picture quality is very poor, please give good picture quality.

  • @mehdibakhtiari300
    @mehdibakhtiari30017 күн бұрын

    You made it really easy to understand!

  • @AutomationMadeEasy
    @AutomationMadeEasy17 күн бұрын

    Thank you

  • @mehdibakhtiari300
    @mehdibakhtiari30016 күн бұрын

    I have still problem with the attachments. My VBA deletes first the pervious emails then attaches the PDF to the new one. At the end an email remains with 10 attachments.@@AutomationMadeEasy

  • @Micomicooo-eo5ee
    @Micomicooo-eo5ee18 күн бұрын

    How can I insert a condition to select lign according to cloumn? So if a line as flag we select client information in that column? Thanks for this video

  • @AutomationMadeEasy
    @AutomationMadeEasy17 күн бұрын

    you can use a simple "if" condition

  • @percypacheco9423
    @percypacheco942319 күн бұрын

    buenas noches como puedo consegir este ejemplo

  • @AutomationMadeEasy
    @AutomationMadeEasy17 күн бұрын

    its on the blog automationandagile.com

  • @zaufeshaali3400
    @zaufeshaali340021 күн бұрын

    hi everyone , I am receiving "The runtime error -2146232576 (80131700) in VBA " in line obj.Start, can someone please help

  • @pranatnath3600
    @pranatnath360021 күн бұрын

    I followed what you have told but still gmap data extractor showing error now what to do

  • @JayChanthalangsy-jx3if
    @JayChanthalangsy-jx3if22 күн бұрын

    I did everything that you said but when I click on the PDF all the values say #REF! like the PDF is not pulling the cell values from the Data sheet. Please advise.

  • @HementKumawat
    @HementKumawat24 күн бұрын

    How i contect you

  • @AutomationMadeEasy
    @AutomationMadeEasy24 күн бұрын

    write into [email protected]

  • @125prado
    @125prado25 күн бұрын

    I'm facing trouble populating the data from google form to the Google Sheet. Any changes to be made in the App script?

  • @CaioVictorPereiraBorges
    @CaioVictorPereiraBorges28 күн бұрын

    Execution error 429 the component ActiveX cannot creat object

  • @ravikalkhudiya6854
    @ravikalkhudiya685429 күн бұрын

    Thank you for the video Dear, can have the app script code As a reply by this command

  • @AutomationMadeEasy
    @AutomationMadeEasy29 күн бұрын

    you can find it on the blog automationandagile.com

  • @user-qc8bz8ue5w
    @user-qc8bz8ue5wАй бұрын

    Please if you can share the file, thank you

  • @AutomationMadeEasy
    @AutomationMadeEasy29 күн бұрын

    you can find it on the blog automationandagile.com

  • @user-sm1dv1km8g
    @user-sm1dv1km8gАй бұрын

    i can't find the script can you please send me

  • @AutomationMadeEasy
    @AutomationMadeEasy29 күн бұрын

    you can find it on the blog automationandagile.com

  • @dvs87
    @dvs87Ай бұрын

    thank a lot for the video! the code really copies, but it is not pasting using the WshShell.SendKeys "^v" .... do u know why?... it seems the code stop to run whenever the file button is clicked and the upload dialog is open... whenever I close it the code continues to run! how can i solve this?

  • @AutomationMadeEasy
    @AutomationMadeEasyАй бұрын

    which os you are you using

  • @dvs87
    @dvs87Ай бұрын

    @@AutomationMadeEasy man thanks a lot i was able to do it watching your other video! I needed to create a extra .VBS function and call it in the main code!

  • @sezzor
    @sezzorАй бұрын

    How to set time through this sir..i can set AM and PM please help

  • @anuragdey3455
    @anuragdey3455Ай бұрын

    सब फर्जी tutorial है, अधूरा ज्ञान देते है। Question पूछेंगे तो जवाब भी नहीं देते।

  • @AutomationMadeEasy
    @AutomationMadeEasyАй бұрын

    kya nhi samja aapko

  • @sameerwagh409
    @sameerwagh409Ай бұрын

    Pls share the code

  • @AutomationMadeEasy
    @AutomationMadeEasyАй бұрын

    its available on the blog automationandagile.com

  • @rezaibrahim8285
    @rezaibrahim8285Ай бұрын

    HELP ME Brother. my question until nine pages. why my response just one page? explain me brother

  • @user-et9rq8po4g
    @user-et9rq8po4gАй бұрын

    Where source code?

  • @vinayveru2535
    @vinayveru2535Ай бұрын

    Thank you soo much ....

  • @AutomationMadeEasy
    @AutomationMadeEasyАй бұрын

    Welcome!

  • @JLa-lw6pe
    @JLa-lw6peАй бұрын

    Keep getting an error message when trying to attach file using this code above it is not reading the drive the file is in.......I am trying to attach an excel file, the file path is correct but keep getting an saying "Cannot find file. Verify the path and file name are correct". How do I fix this?

  • @AutomationMadeEasy
    @AutomationMadeEasyАй бұрын

    need to see your code

  • @JLa-lw6pe
    @JLa-lw6peАй бұрын

    Can you send an excel spreadsheet using this code?

  • @Srikanth-lb3gl
    @Srikanth-lb3glАй бұрын

    Hi, I want to send only attachment, kindly share the code, Thanks in Advance

  • @AutomationMadeEasy
    @AutomationMadeEasyАй бұрын

    its available on the blog automationandagile.com

  • @Srikanth-lb3gl
    @Srikanth-lb3glАй бұрын

    Hi, Could you please share the code, Thanks in Advance

  • @user-kd2jv7wg8h
    @user-kd2jv7wg8hАй бұрын

    very helpful video sir keep posting such amazing stuff Excellent and well done What if we have dynamic UI elements which means is time field values shuffle and after every refresh name value is also change. Please help me with this problem.

  • @jakerusbarsky7023
    @jakerusbarsky7023Ай бұрын

    You made this video extremely easy to understand, especially to people who do not have a background in code. I was wondering if there is a way to do this if you were to navigate to different web pages? A project I am working on requires me to search a website for 47,000 cells of data and retrieve a line of information. Thanks again for your help!

  • @AutomationMadeEasy
    @AutomationMadeEasyАй бұрын

    Similar examples are provided on the blog automationandagile.com in Excel automation section. For you specific requirement I need to see the web page to suggest a solution

  • @edmunds.3222
    @edmunds.3222Ай бұрын

    This is no longer applicable in June 15, 2022 onwards since IE no longer exist. Is there any way to Automate Data Entry from excel to Chrome ? Tq

  • @AutomationMadeEasy
    @AutomationMadeEasyАй бұрын

    refer below tutorial kzread.info/dash/bejne/c3mkkruemdafcbA.html

  • @JeremyAtkins-ix8fc
    @JeremyAtkins-ix8fcАй бұрын

    awesome, exactly what i needed to see :)

  • @AutomationMadeEasy
    @AutomationMadeEasyАй бұрын

    Get Started With LidoApp Sheets: www.lido.app/link/automationagile

  • @Asilcouple143
    @Asilcouple1432 ай бұрын

    This was only one data you used here but in data entry job there was multiple data i need to enter please help me to do that

  • @UmeshDube-cy4po
    @UmeshDube-cy4po2 ай бұрын

    If my email should be sent based on today's date then how it can be possible

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    you just need current date of content also based on dates?

  • @tokobukusalaf
    @tokobukusalaf2 ай бұрын

    Failed gan. teamwbk ('application/pdf') how?...

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    I did not understand your question

  • @truewisdomjunction
    @truewisdomjunction2 ай бұрын

    What If I want to use button on mobile device as well????

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    does not work

  • @truewisdomjunction
    @truewisdomjunction2 ай бұрын

    @@AutomationMadeEasy okay thanks

  • @PURIANS3
    @PURIANS32 ай бұрын

    After column g your formula is not working so how we work upto O column

  • @redheadsg1
    @redheadsg12 ай бұрын

    So, how to you save this macro to Java booklet or bookmark so i can use it in Shortkey plugin ???

  • @dannybejjani
    @dannybejjani2 ай бұрын

    Thank you for this wonderfull tutorial, but what if I want to send the header and the last entered row in a table?

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    well that will need some coding where you will use only the header row and the last row in the excel to get the desired data

  • @user-nk8ly9iy3p
    @user-nk8ly9iy3p2 ай бұрын

    Hi, I am very happy to see your video. I have an issues that is my total employee 5person but when I applied your code then just created pdf for one employee that is in row no 2. please help me to solve this problem.

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    check your loop may be the syntax for creating final pdf is placed outside the loop

  • @anandmore6430
    @anandmore64302 ай бұрын

    My chrome is not working, what may be possibility??

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    what is the error?

  • @anandmore6430
    @anandmore64302 ай бұрын

    @@AutomationMadeEasy Run-Time Error '-2146232576 (80131700) Automation Error, my code is as follow Dim obj As New WebDriver Sub test() obj.SetBinary ("C:\Users\Admin\AppData\Local\SeleniumBasic\chrome-win64\chrome-win64\chrome.exe") obj.Start "Chrome", "" obj.Get "eportal.incometax.gov.in/iec/foservices/#/login" End Sub When i debug this it showing erroer at obj.SetBinary

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    dot net 3.5 might be missing

  • @anandmore6430
    @anandmore64302 ай бұрын

    @@AutomationMadeEasy I will check this. Thank you so much for replying

  • @anandmore6430
    @anandmore64302 ай бұрын

    @@AutomationMadeEasy Yes, it working now. thank you so much 👍

  • @yohanesphilis5958
    @yohanesphilis59582 ай бұрын

    nice video, but what if you dont want to submit it, like what would you do if you just wanted to fill out one form, and then you can manually check it and then submit it on your own, how would you do that?

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    not sure about that, but we could implement a number of checks before the form is submitted to ensure correct submission

  • @MARIOFILHO-vz8xb
    @MARIOFILHO-vz8xb2 ай бұрын

    You are big!! Thanks!

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    You're welcome!

  • @user-bf5qu5ot8s
    @user-bf5qu5ot8s2 ай бұрын

    hi how can i contact you i have a programming job

  • @AutomationMadeEasy
    @AutomationMadeEasy2 ай бұрын

    write into [email protected]

  • @rumim007
    @rumim0072 ай бұрын

    IS IT POSSIBLE AN USERFORM COMMANBUTTON WILL OPEN A PDF FILE. SOME ELEMENT WILL READ THE LAST READ PAGE NUMBER AND STORE IN SHEET 1 COLUMN A. AND ANOTHER COMMANDBUTTON WILL RESUME READING FROM THE LAST READ PAGE NUMBER? EXCEL FILE WILL OPEN IN MOZILLA PDF VIEWER. IF POSSIBLE MAKE A VIDEO WITH THIS

  • @TheOnlyEpsilonAlpha
    @TheOnlyEpsilonAlpha2 ай бұрын

    Long Story short summary: - Buttons are useless on mobile because Googles Implementation is dumb - You need to trigger a function that runs every time when anywhere something is changing "Thanks" Google ...