Extreme Automation - Kamal Girdher
Extreme Automation - Kamal Girdher
  • 206
  • 1 464 832

Video

Comments

  • ramesh patel
    ramesh patel Day ago

    sir, i am using multiple sheets in excel workbook, when i use macro with automatic time interval it will also change my data when i am working on another sheet of same workbook. please sir suggest some correction so that it can work in one particular sheet of workbook and not apply to all sheets of workbook.

  • Ly Lo
    Ly Lo Day ago

    Hello, I am new at this, this is the current method we have set up from a previous person, using Lotus notes, How can I rewrite this to outlook.

  • Vaibhav Dasharathe
    Vaibhav Dasharathe 3 days ago

    hey it was good tutorial but can you plz soften your voice it will feel good listen

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 2 days ago

      Sure Vaibhav. The issue was due to the old recording setup I was using. I have changed it now and in new videos you would hear better audio quality.. Hope that help. Stay connected!

  • spurdsy
    spurdsy 7 days ago

    thank you so much

  • BETDOCTOR
    BETDOCTOR 8 days ago

    Hi , If the ID value of the selection box is the same, How do I get data-row selected ? example : <input id="00" type="checkbox" data-group="0" data-column="0" data-row="1"> <input id="00" type="checkbox" data-group="0" data-column="0" data-row="2"> "ie.Document.getElementById("00").Checked = True" I'm waiting for help "data-row(1) and data-row(2)" mailadress: bahisdoktoru@mail.com.tr

  • Kailash Sati
    Kailash Sati 11 days ago

    there is a problem loading the picture.

  • krishnakishore peddisetti

    this is just awesome ... simple and easy to implement ...thanks a lot my friend

  • pimpomfossils
    pimpomfossils 12 days ago

    Hi, please do it slightly slow. It will help us understand.

  • coolag74
    coolag74 12 days ago

    Want some help in Excel VBA, can I expect from you...

  • deepak singh
    deepak singh 12 days ago

    hey Kamal, can you please explain how to get data from complex XML structure.. for ex - <data value="100">actualvalue</data> Above is the just one of the tag from my XML, and lets say I have to retrieve actualvalue as result then how we can proceed ? I am subscribing your channel.. hoping to get my answer soon :) Good Day!

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 2 days ago

      sure. I'll reply on this soon.

    • deepak singh
      deepak singh 11 days ago

      @Extreme Automation - Kamal Girdher hey youtube doesnt allow us to upload pictures in replies and I cant copy my XML so cant give you the exact one.. I have googled and got below XML which is bit related - <Segment name="TMD" comment="To describe the nature of the test performed"> <Field name="ProductProcessCharacteristicCode" required="y" min="2" max="3" validation="T750" comment="Code identifying the general class of a product or process characteristic"/> <Field name="AgencyQualifierCode" required="y" min="2" max="2" validation="T559" comment="Code identifying the agency assigning the code values"/> <Field name="ProductDescriptionCode" required="y" min="1" max="12" comment="A code from an industry code list which provides specific data about a product characteristic"/> <Field name="TestAdministrationMethodCode" required="y" min="2" max="2" validation="T937" comment="Code specifying the method of administering the test"/> <Field name="TestMediumCode" required="y" min="2" max="2" validation="T938" comment="Code specifying organism on which the test was performed"/> <Field name="Description" required="y" min="1" max="80" comment="A free-form description to clarify the related data elements and their content"/> <Field name="Date" required="y" min="8" max="8" comment="Date expressed as CCYYMMDD where CC represents the first two digits of the calendar year"/> <Field name="ReferenceIdentification" required="y" min="1" max="50" comment="Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier"/> <Field name="SourceSubqualifier" required="y" min="1" max="15" comment="A reference that indicates the table or text maintained by the Source Qualifier"/> </Segment> From above XML if we want to fetch the value of "min" and "comment" from tag ProductProcessCharacteristicCode then how we can write that code.. I have tried but I am getting "None"

    • deepak singh
      deepak singh 11 days ago

      ​@Extreme Automation - Kamal Girdher​ok let me try to get that.. not sure if I can get you the exact XML that I am going to work on (office project).. but will try to get atleast similar to that...

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 11 days ago

      sure Deepak... If you have an example xml then share with me.

  • Guido
    Guido 13 days ago

    Nice example, thanks.... you can improve the spinning visual with a smoother slowing of the wheel as follows : 1) Add another variable called spinDegree in the spinWheel() routine 2) add the following code : If (i Mod 10) = 0 Then spinDegree = 10 - (i / 10) End If ActiveSheet.Shapes("shape1").IncrementRotation spinDegree in place of... ActiveSheet.Shapes("shape1").IncrementRotation 10

  • WoLFyy THETHE
    WoLFyy THETHE 13 days ago

    i have downloaded ngrok.exe for cmd windows 7 i put it ont c:/windows to execute it in cmd i wrote a bat file in it @echo off start ngrok and i created a vbs file to make it invisible it still dont work except if i let it showing the black screen of ngrok tcp etc any solution? :D

  • Messahel Messaoud
    Messahel Messaoud 16 days ago

    hello its not working 100% for me for more info i use formatting table "table1" its work when i type but when i remove characters rows stay hide

    • Messahel Messaoud
      Messahel Messaoud 13 days ago

      @Extreme Automation - Kamal Girdher thx also i experement this trick with date field it not working with date fields ..why

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 14 days ago

      I believe you are looking for a filter that work for numbers. Here it is ru-clip.net/video/wajVO5v4eKc/video.html

  • S Kumar
    S Kumar 16 days ago

    Sir can you please make video tutorial for automations like some websites which has multiple page but URL remains the same whether any pages you move but URL doesn't change in URL bar. If possible time then please do a favour to upload tutorial

  • S Kumar
    S Kumar 16 days ago

    Awesome sir, thanks

  • S Kumar
    S Kumar 16 days ago

    Thanks sir honestly best explained

  • kurban ali
    kurban ali 18 days ago

    Hi sir good morning It's really good job and I am very helpful on this tutorial Sir I have two three lines sentence out of that I need change two words for every email how to do that

    • kurban ali
      kurban ali 14 days ago

      Hi sir I am try to use the same method which one you have shown, I want to send one sentence out of that person name and DOB need to changed for every receptionist

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 15 days ago

      @Kurban Ali - please share more precise details of your question. Share the code/snippet/input/output etc.

  • Swapnil Sakpal
    Swapnil Sakpal 19 days ago

    Fabulous series of web scraping. Thanks a ton. I'm trying to make macro in which I've names of various companies in a row and in next row it should display the share price of it. can you please assist me in the same. i'm learning from your series. but couldn't connect the logics in this program. maybe some mistakes. please make a video on how to take data from a range of cells, and display results, also if i've range of websites then how to grab data.

  • Keith McTaggart
    Keith McTaggart 19 days ago

    can you add some code to include all files in subfolders of the folder chosen to rename please

  • IGB Suarsana
    IGB Suarsana 20 days ago

    Hello sir, I can already apply my place and I say thank you. No one I want to make, the example in minutes to 11.15 you typed 345,Hello sir, I can already apply my place and I say thank you. No one I want to make, the example in minutes to 11.15 you typed 345, "internal id"The top one is 1534xxxx, I want to take it automatically the top-most in the Internal ID column, to in Sheet2 that is already konek with Sheet1 by using VLOOKUP. In Sheet2 are the column details per ID horizontally. Sorry my English ugly

  • CHANDAKA ASHOK
    CHANDAKA ASHOK 21 day ago

    Brother, i need help.. to extract bounced mails from Outlook in to excel sheet. Please help...

  • H Stevens
    H Stevens 22 days ago

    As_key

  • SB
    SB 22 days ago

    Hi how to contact you. Can help me in importing json data to my python code

  • Ramkrishna Kale
    Ramkrishna Kale 26 days ago

    i tried so many time but it cant works

  • Ramkrishna Kale
    Ramkrishna Kale 26 days ago

    pls send me the link on its my hmble request to u

  • Accelpix- NSE Authorised Real Time Data Vendor

    Nice cod.. Thanks a lot

  • kurban ali
    kurban ali 27 days ago

    Hi sir can be used from address also I want to send mail from common ID mail merge it's not possible

    • kurban ali
      kurban ali 24 days ago

      Hi sir good morning I have two email ID one is my personal and one more common Mail ID. I want to use common Mail ID is it possible

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 24 days ago

      Hello Kurban Ali, I didn't understand your question. Please explain..

  • Ezaz M Mashraken
    Ezaz M Mashraken 29 days ago

    thank you sir, this is very helpful could you plz help me to change the filter of pivot table plz

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 24 days ago

      don't worry. share your file as I said.

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 24 days ago

      the same should work I believe. Try to fit it in there. If you get stuck, then share your file with me.

    • Ramkrishna Kale
      Ramkrishna Kale 26 days ago

      kaise helpfull hy bato 3 din se try kar raha haon sala ban raha hai lekin use nahi ho raha hai konsa bhi item ka naam type karo to 1st no ka item he show kar raha hai

  • Ryan
    Ryan Month ago

    I'm doing some raffle draw wheels, what code should i use to avoid repeats of picking the winner?

  • mukesh kumar
    mukesh kumar Month ago

    Nice video sir, i learnt lot from your video and please continue to upload this type of video. Sir in order to click google search we can use this simple vba code also , i tried this ,this is working doc.getElementById("btnK").Click or doc.forms(0).submit

  • shah abbas
    shah abbas Month ago

    I am not getting the id of the tags.Please figure out the error. here is my error and code: SyntaxError: invalid syntax import xml.etree.cElementTree as ET tree = ET.ElementTree(file='C:\\Users\\abbas\\IU xrays reports\\1.xml') root = tree.getroot() for chld in root: if(chld.tag=='parentImage'): #print(chld) print chld.get('id' + '\n') <?xml version="1.0" encoding="utf-8"?> <eCitation> <meta type="rr"/> <uId id="CXR1"/> <pmcId id="1"/> <docSource>CXR</docSource> <IUXRId id="1"/> <licenseType>open-access</licenseType> <licenseURL>creativecommons.org/licenses/by-nc-nd/4.0/</licenseURL> <ccLicense>byncnd</ccLicense> <articleURL/> <articleDate>2013-08-01</articleDate> <articleType>XR</articleType> <publisher>Indiana University</publisher> <title>Indiana University Chest X-ray Collection</title> <note>The data are drawn from multiple hospital systems.</note> <specialty>pulmonary diseases</specialty> <subset>CXR</subset> <MedlineCitation Owner="Indiana University" Status="supplied by publisher"> <Article PubModel="Electronic"> <Journal> <JournalIssue> <PubDate> <Year>2013</Year> <Month>08</Month> <Day>01</Day> </PubDate> </JournalIssue> </Journal> <ArticleTitle>Indiana University Chest X-ray Collection</ArticleTitle> <Abstract> <AbstractText Label="COMPARISON">None.</AbstractText> <AbstractText Label="INDICATION">Positive TB test</AbstractText> <AbstractText Label="FINDINGS">The cardiac silhouette and mediastinum size are within normal limits. There is no pulmonary edema. There is no focal consolidation. There are no XXXX of a pleural effusion. There is no evidence of pneumothorax.</AbstractText> <AbstractText Label="IMPRESSION">Normal chest x-XXXX.</AbstractText> </Abstract> <Affiliation>Indiana University</Affiliation> <AuthorList CompleteYN="Y"> <Author ValidYN="Y"> <LastName>Kohli</LastName> <ForeName>Marc</ForeName> <Initials>MD</Initials> </Author> <Author ValidYN="Y"> <LastName>Rosenman</LastName> <ForeName>Marc</ForeName> <Initials>M</Initials> </Author> </AuthorList> <Language>eng</Language> <PublicationTypeList> <PublicationType>Radiology Report</PublicationType> </PublicationTypeList> <ArticleDate> <Year>2013</Year> <Month>08</Month> <Day>01</Day> </ArticleDate> </Article> <EssieArticleTitle>Indiana University Chest X-ray Collection</EssieArticleTitle> <IMedAuthor>Marc David Kohli MD</IMedAuthor> <IMedAuthor>Marc Rosenman M</IMedAuthor> </MedlineCitation> <MeSH> <major>normal</major> </MeSH> <parentImage id="CXR1_1_IM-0001-3001"> <figureId>F1</figureId> <caption>Xray Chest PA and Lateral</caption> <panel type="single"> <url>/hadoop/storage/radiology/extract/CXR1_1_IM-0001-3001.jpg</url> <imgModality>7</imgModality> <region type="panel"> <globalImageFeatures> <CEDD>f2p0k1352</CEDD> <ColorLayout>f1p0k36</ColorLayout> <EdgeHistogram>f0p0k969</EdgeHistogram> <FCTH>f4p0k2423</FCTH> <SemanticContext60>f3p0k305</SemanticContext60> </globalImageFeatures> </region> </panel> </parentImage> <parentImage id="CXR1_1_IM-0001-4001"> <figureId>F2</figureId> <caption>Xray Chest PA and Lateral</caption> <panel type="single"> <url>/hadoop/storage/radiology/extract/CXR1_1_IM-0001-4001.jpg</url> <imgModality>7</imgModality> <region type="panel"> <globalImageFeatures> <CEDD>f2p0k1013</CEDD> <ColorLayout>f1p0k36</ColorLayout> <EdgeHistogram>f0p0k184</EdgeHistogram> <FCTH>f4p0k1133</FCTH> <SemanticContext60>f3p0k277</SemanticContext60> </globalImageFeatures> </region> </panel> </parentImage> </eCitation>

  • Mr. Bhaskar
    Mr. Bhaskar Month ago

    Sir how about the career of Annotation Engineer...?

  • Aswath K Nalin
    Aswath K Nalin Month ago

    This is life savior. Thanks a lot for this tool

  • Scott Nantell
    Scott Nantell Month ago

    First macro runs fine. The 2nd didn't work and kept generating a run-time error.

  • Rohan Yemul
    Rohan Yemul Month ago

    whats syntax for 3 version

  • Karthikeyani kaarthik

    Clear cut comparison. Thanks a lot!

  • LALIT KUMAR
    LALIT KUMAR Month ago

    Nice video and good code for file information but sir i want to learn more aboutr filesystem and onj and call function so please more video for obj set and call file system thanx i injoy also and also save ur number sir for any queries for any programming i send msj to help us.. bunty016@gmail.com my.mail id if u have any pdf file any learning material for vba send me thanks again

  • Spiti Sawant
    Spiti Sawant Month ago

    It throws error to me when I run - MsgBox ActiveSheet.Shapes("shape1").lft It says: Run-time error. The item with the specified name wasn't found. Can you help?

  • Hailey Bradshaw
    Hailey Bradshaw Month ago

    This is exactly what i needed. Thank you

  • Megha Bisht
    Megha Bisht Month ago

    thanks sir!!!

  • Andreas Lechthaler
    Andreas Lechthaler 2 months ago

    thx! very useful!!!

  • Khirod Kumar
    Khirod Kumar 2 months ago

    Good job, small video but explain clearly thanks

    • Khirod Kumar
      Khirod Kumar Month ago

      Please solve this question easy method. Raju58ghj Hinans896gty 48gyt Frtegh794 Separate number and text in Excel and VBA

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher Month ago

      Thank you Khirod. Your words mean a lot to me and these give me energy to put more and more content for my friends on youtube.. Stay connected!

  • niZmo
    niZmo 2 months ago

    i pretty much copy the code (except the folder path) on the video but somehow getting Compile error: Variable not defined. on the line 'Function GetFileDetails(objfolder As Scripting.Folder) why is that?

  • Hari Prasad
    Hari Prasad 2 months ago

    Thank you for your videos and it is very useful, simple to learn the things.

  • Nicolas Fedrigo
    Nicolas Fedrigo 2 months ago

    really very useful, but how do I if I just want pdf files?

    • Nicolas Fedrigo
      Nicolas Fedrigo 2 months ago

      @Extreme Automation - Kamal Girdher Yes, thanks

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 2 months ago

      @Nicolas - you can add a if condition while writing in the cell. The condition would be checking if that file name ends with .pdf Is it clear??

  • Tamer Morsy
    Tamer Morsy 2 months ago

    Hi, thanks for sharing, does it works fine with online google sheets? Does Google online sheet accept it?

  • C U
    C U 2 months ago

    What is this batch gikr and what can it be used to do and can it be done with none bat files

  • mintmo
    mintmo 2 months ago

    Great video! Would this work on a shared drive?

  • Free2 Fly
    Free2 Fly 2 months ago

    When will it stop?

  • Billy
    Billy 2 months ago

    Can you show me a way to have text file with a = 10.35 b = 20.57 c = 30.79 on separate lines and get program to only read the variable decimal values and assign them to variables a, b, c in the program.

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 2 months ago

      @Billy, here is the code: with open('inp.txt') as f: for x in f.readlines(): vars()[x.split("=")[0].strip()]=x.split("=")[1].strip().split(".")[0]

  • Amit Sharma
    Amit Sharma 2 months ago

    Hi Sir, need a small help, actually i need to copy data from one worksheet to another only when the headers of both worksheets match. i have written a code which is actually copying the entire range from one worksheet to another but actually the situation is, once the headers match, the data gets copied and then next time the data should get copied skipping one row in destination worksheet. please help

    • Amit Sharma
      Amit Sharma Month ago

      Hi Kamal..its fine..no need to be sorry..I have resolved the issue..and thanks for your response

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher Month ago

      Hi Amit, sorry for replying late. Please share your file with me. I'll help you in fixing the issue.

  • billing btk
    billing btk 2 months ago

    Sir can you tell me easiest way to attached PDF multiple files?

  • धनंजय गवळी

    Hi, I want to change extensions of files presents in subfolder.

  • Imad Tamer
    Imad Tamer 2 months ago

    Hello to all, I have 4000 files in .doc to convert into .docm. I thaught that the macro as shown in the video would have helped. Unfortunately this message is poping up "cannot run the macro. The macro may not be available in this workbook or all macros may be disabled" I have enabled all macros, still the same issue. Does anyone have a solution? Thank in advance

  • Tushar Rewatkar
    Tushar Rewatkar 2 months ago

    In which editor you are writing the code?

  • Arpit Vijay
    Arpit Vijay 2 months ago

    How if we want to create a function out of this. I want cell to take input from other cell references and print the largest number.

    • Arpit Vijay
      Arpit Vijay 2 months ago

      I wrote this is is fine. Function largestx(a As Integer, b As Integer, c As Integer) test1 = Evaluate(a) test2 = Evaluate(b) test3 = Evaluate(c) If test1 = a < b And c Then largestx = a ElseIf test2 = b < a And c Then largestx = b Else largestx = c End If End Function

  • Arpit Vijay
    Arpit Vijay 2 months ago

    How do you align code vba ? shortcut for windows

  • VarietyTV
    VarietyTV 2 months ago

    macro may not be available on this workbook or all macros may be disabled

    • Aswath K Nalin
      Aswath K Nalin Month ago

      Right click on get file names. Select macros. Fetch files..edit. and change the location

  • Kurt Dhadamus
    Kurt Dhadamus 2 months ago

    This is wat I can use, can you sent de code please

  • Tajammul Hussain Khadir

    Highly appreciated kamal Many thanks for your kindness

  • Jonas Berg
    Jonas Berg 2 months ago

    Hi. I get "variable not defined" when running "xlOp"?

  • goldeneras
    goldeneras 2 months ago

    How did you get the "Add Buttons" and "Remove" buttons on the top ?

  • Susanta Kumar
    Susanta Kumar 2 months ago

    Hi Kamal, I appreciate your good work. I have a query for an off-topic please make a video on it if it's possible. I don't want the close button (red X in the upper right corner) to be visible in a userform. How do I remove it?

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 2 months ago

      @Susanta - Thank you so much for your kind words. It really means a lot reading comments like this.. I'll look into your query and respond soon.

  • Farhan Islam
    Farhan Islam 2 months ago

    HOW TO COPY DATA ANOTHER SHEET AFTER DYNAMAICALYY FILTERED

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 2 months ago

      Hi Farhan, it is easy. Send me ur file and I'll add this piece of code in your file.. excel.microk@gmail.com

    • Farhan Islam
      Farhan Islam 2 months ago

      @Extreme Automation - Kamal Girdher Kindly share code in description

    • Farhan Islam
      Farhan Islam 2 months ago

      @Extreme Automation - Kamal Girdher IT WILL A GREAT HELP ME IF U FAVOUR ME

    • Farhan Islam
      Farhan Islam 2 months ago

      @Extreme Automation - Kamal Girdher Through VBA code .when i write product name, then filter it and after that copy paste button ,paste filtered data on other sheet

    • Farhan Islam
      Farhan Islam 2 months ago

      @Extreme Automation - Kamal Girdher thanks

  • MARIOS D
    MARIOS D 2 months ago

    nice !

  • Edwin Xiao
    Edwin Xiao 2 months ago

    Hi, I used your exact code, but it cannot launch firefox at all. It launched Chrome, but does not display google.com. Could you tell me if I have missed something. Your website is great, btw. Dim driver As SeleniumWrapper.WebDriver Set driver = New SeleniumWrapper.WebDriver driver.Start "firefox", "www.google.com" driver.Open "/"

  • Reun Im
    Reun Im 3 months ago

    It is difficult sometimes can lock and sometimes cannot.

  • Reun Im
    Reun Im 3 months ago

    When I followed yr video my file lost vba code

  • Casandra Langley
    Casandra Langley 3 months ago

    Can you help me with recognize text ocr on multiple Ms word files? I need to be able to retitle and date multiple documents (documents are all Ms word and the page is setup the same), please? The date and title have to be from the document itself not the file details in Windows Explorer.

  • MUHAMMED NAFI UMMINIYATTIL

    Thanks for the vedio. I have a doubt.how sent mail to multiple ID in cc/to .if fill the idies in one cell outlook show error that mail idies not available.in simple how to separate different idies

  • pragnesh parmar
    pragnesh parmar 3 months ago

    unable to do and getting error as " user defined type no defined"

  • sudarson t
    sudarson t 3 months ago

    can you share me prerequisites before executing the script

  • Roux Romain
    Roux Romain 3 months ago

    Hi, I'm glad someone make a vidéo about the slider contro because i was searching for it for 2 months now. I'm working on a dashboard on Excel and I need to implement this kind of slider control to manipulate my graphic scales on X and Y axes. Can you put a link redirecting to your file so i can take a look on how you did it ?Thks a lot.

  • Sudipta Manna
    Sudipta Manna 3 months ago

    Not understand properly...

    • Sudipta Manna
      Sudipta Manna 2 months ago

      @Extreme Automation - Kamal Girdher Sir, Vlook up and Hlook up understand properly ..But when I create Index and Match Function its some time not clear properly.. I used before index and Match function in excel multiple way... but when its used single way its difficult ... Could i used Multilple way properly?

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 3 months ago

      @Sudipta - watch again and let me know which part is not clear to you..

  • 劉任昌
    劉任昌 3 months ago

    This is a fascinating example for teaching programming.

    • 劉任昌
      劉任昌 3 months ago

      @Extreme Automation - Kamal Girdher I made a video teaching Excel in Chinese, part of which replicating your approach. I have credited your contribution. see 4m in the video. ru-clip.net/video/MlUEBY8WUpo/video.html

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 3 months ago

      Thank you!😀

  • Bagus Indrajatmoko
    Bagus Indrajatmoko 3 months ago

    Hello Sir, i try to make the VBA but when i press start the timer only decrease 1 second an then stop, its not continue running like yours, can you help me with the full tutorial or anything? Thanks

  • Will M
    Will M 3 months ago

    Does this share the browser installation with a Python gecko based install? The firefox browser starts up but doesnt connect in time. Error : Firefox failed to open the listening port 127.0.0.1.59421 within 15s

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 3 months ago

      It has nothing to do with python. But you need to have geckodriver present in PATH variable. So, if you have gecodriver present on your desktop, add that path to PATH environment variable.

  • xiang li
    xiang li 3 months ago

    hi, can you upload the prj to github and how to Transfer jmeter script to Robot script ,Thanks

  • rishab nigam
    rishab nigam 3 months ago

    how did you setup emulator

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 3 months ago

      You can use the one provided in android studio itself. And yes you can use it for scraping.

    • rishab nigam
      rishab nigam 3 months ago

      which one are freely available??? Is it possible to use them scraping information into excel??

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 3 months ago

      Ho Rishabh. I used genymotion emulator for this. However, their emulators are not free now as far as i know. So you can try any other emulator software..

  • Vinay Borkar
    Vinay Borkar 3 months ago

    This is not working when we replace .display with .send, even the mail body is also disappread

    • Paul Chung
      Paul Chung 25 days ago

      I am also trying to send out a bulk email

    • Paul Chung
      Paul Chung 25 days ago

      So what was the solution to this? I had the same problem

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 3 months ago

      Do you have signature set up in outlook? If yes, send me ur excel file and screenshot of a blank outlook email(create a new mail and take screenshot.).

    • Vinay Borkar
      Vinay Borkar 3 months ago

      @Extreme Automation - Kamal Girdher This is already updated but still not getting signature while using .send

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 3 months ago

      Use Application.Screenupdating = False in the beginning and Application.Screenupdating = True in the end.

  • Tao Li
    Tao Li 3 months ago

    very good. Thanks sharing.

  • FlautitandoIsis
    FlautitandoIsis 3 months ago

    Parabéns ótimo vídeo...

  • Sagar Roy
    Sagar Roy 3 months ago

    I am stuck in a problem plz help me out, how can share the problem

  • Elias Daoud
    Elias Daoud 3 months ago

    After revising my code and samples. I am sure 100% the "Name" statement is for kids. and this issue is closed / terminated for me. and I bet Microsoft themselves about this issue. The Name statement cannot rename an old file with space or such (and I don't know why) 360_0000 to become 360_0001 but it can be to 460_0001 or 370_0001 or any but not starting with 360. this mean it has problem with space " " and "_" in a way or zeros. such 360_0002 can be renamed to 360_0001 or any other

  • Tony Hallett
    Tony Hallett 3 months ago

    What colour number is the purple, please? Great videos!

  • Elias Daoud
    Elias Daoud 3 months ago

    Please can you try file names with space in your program in this video? does this work? example "C:\test\360_00 67.jpg" space included

  • Elias Daoud
    Elias Daoud 3 months ago

    Moreover, to my previous comment and after using Name statement. I can say it is unstuck, failing or good-for-nothing. Unpredictable errors or fail to rename files (sure they are not opened, not readonly)

    • Elias Daoud
      Elias Daoud 3 months ago

      @Extreme Automation - Kamal Girdher I am sure, can you tell me why one of the following lines work where the other not ? I am programmer (~33 years) for many Languages. and mainly Mech Eng. so I can understand you fast. (.JPG & .jpg work both) Name "D:\Test\660_000010.JPG" As "D:\Test\760_0009.JPG" work Name "D:\Test\660_000010.JPG" As "D:\Test\660_0009.JPG" doesn't work This is one of many Name "D:\Test\660_0008.JPG" As "D:\Test\660_0001.JPG" work Name "D:\Test\660_0000.JPG" As "D:\Test\660_0001.JPG" doesn't work

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 3 months ago

      Relax Elias. I am sure you must be doing something wrong. Share your code with me.

  • Pranav Garbhe
    Pranav Garbhe 3 months ago

    This is what I want .... thank you very much sir......hats off to u

  • Tom Micua
    Tom Micua 3 months ago

    I followed your code however mine spins very slowly.

  • Sidharth Pattanayak
    Sidharth Pattanayak 4 months ago

    Make some video of Excel VBA with Chrome using Selenium

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 4 months ago

      @Sidharth - Thank you for watching. I would suggest not to use excel to automate chrome or firefox using Selenium wrappers. These exist but are not recommended. There are very good frameworks for web automation using selenium. TestNG is one of them. You would be easily tracked if doing scraping using webdriver etc. Though Excel vba + IE is a great combination for data scraping. So if your purpose is automation, better you opt for Python or Java. Feel free to discuss more if you have questions!

  • Sidharth Pattanayak
    Sidharth Pattanayak 4 months ago

    Can we use TestNG in Excel VBA Selenium

  • Topu Saiful
    Topu Saiful 4 months ago

    It's not working. I have written the same code that you have described but it is not printing the "title" on immediate window. Did you activated other references from tools section? Microsoft HTML Object Library and Microsoft Internet Controls I think apart from those two you have tried other references. Hope I will get the answer. In the end, Thank you so much for bringing this kind of tutorial for us. You have described very well just need some few clarification that I am facing right now. Hope I will get answer. God Bless you..

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 4 months ago

      To receive notifications, you need to subscribe and CLICK on BELL ICON.

    • Topu Saiful
      Topu Saiful 4 months ago

      Hey, Thanks for your response. I am really sorry I didn't notice your reply. Actually I didn't get any notification from youtube that you have replied my comment. That's the reason I am reaching to you late. here is the file link www.dropbox.com/s/uaodtl0uy52i8um/PlayStore_Scraping.xlsm?dl=0

    • Extreme Automation - Kamal Girdher
      Extreme Automation - Kamal Girdher 4 months ago

      Send me ur file with code.

  • MA-AM
    MA-AM 4 months ago

    great thanks Kamal, ramadan kareem

  • Neeta gupta
    Neeta gupta 4 months ago

    👍

  • Neeta gupta
    Neeta gupta 4 months ago

    👍

  • Neeta gupta
    Neeta gupta 4 months ago

    Great Job You are doing 👍

  • anjali kumari
    anjali kumari 4 months ago

    Can you please explain the same things using Minidom?

  • vukvolkov
    vukvolkov 4 months ago

    Amazing stuff!

  • dinesh solanki
    dinesh solanki 4 months ago

    Hi Kamal, Thank you for the video. I tried the concept with www.fabindia.com/clothing/men-kurtas and to my surprise i only get a list of 12 kurtas. (while there are about 1100 of them!) Could you please explain why?

  • Neeta gupta
    Neeta gupta 4 months ago

    👍 Please make video's on Web scrapping interview question as well.