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
Пікірлер
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
Thank you sir !
Most welcome!
From where i can find the script
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
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
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 .
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.
Picture quality is very poor, please give good picture quality.
You made it really easy to understand!
Thank you
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
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
you can use a simple "if" condition
buenas noches como puedo consegir este ejemplo
its on the blog automationandagile.com
hi everyone , I am receiving "The runtime error -2146232576 (80131700) in VBA " in line obj.Start, can someone please help
I followed what you have told but still gmap data extractor showing error now what to do
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.
How i contect you
write into [email protected]
I'm facing trouble populating the data from google form to the Google Sheet. Any changes to be made in the App script?
Execution error 429 the component ActiveX cannot creat object
Thank you for the video Dear, can have the app script code As a reply by this command
you can find it on the blog automationandagile.com
Please if you can share the file, thank you
you can find it on the blog automationandagile.com
i can't find the script can you please send me
you can find it on the blog automationandagile.com
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?
which os you are you using
@@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!
How to set time through this sir..i can set AM and PM please help
सब फर्जी tutorial है, अधूरा ज्ञान देते है। Question पूछेंगे तो जवाब भी नहीं देते।
kya nhi samja aapko
Pls share the code
its available on the blog automationandagile.com
HELP ME Brother. my question until nine pages. why my response just one page? explain me brother
Where source code?
Thank you soo much ....
Welcome!
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?
need to see your code
Can you send an excel spreadsheet using this code?
Hi, I want to send only attachment, kindly share the code, Thanks in Advance
its available on the blog automationandagile.com
Hi, Could you please share the code, Thanks in Advance
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.
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!
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
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
refer below tutorial kzread.info/dash/bejne/c3mkkruemdafcbA.html
awesome, exactly what i needed to see :)
Get Started With LidoApp Sheets: www.lido.app/link/automationagile
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
If my email should be sent based on today's date then how it can be possible
you just need current date of content also based on dates?
Failed gan. teamwbk ('application/pdf') how?...
I did not understand your question
What If I want to use button on mobile device as well????
does not work
@@AutomationMadeEasy okay thanks
After column g your formula is not working so how we work upto O column
So, how to you save this macro to Java booklet or bookmark so i can use it in Shortkey plugin ???
Thank you for this wonderfull tutorial, but what if I want to send the header and the last entered row in a table?
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
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.
check your loop may be the syntax for creating final pdf is placed outside the loop
My chrome is not working, what may be possibility??
what is the error?
@@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
dot net 3.5 might be missing
@@AutomationMadeEasy I will check this. Thank you so much for replying
@@AutomationMadeEasy Yes, it working now. thank you so much 👍
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?
not sure about that, but we could implement a number of checks before the form is submitted to ensure correct submission
You are big!! Thanks!
You're welcome!
hi how can i contact you i have a programming job
write into [email protected]
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
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 ...