Word VBA - Bookmarks Basics
10:28
9 ай бұрын
Пікірлер
@4thgearyt991
@4thgearyt991 6 күн бұрын
Code is really helpful but can we give seperate names (from the main pdf) to pdf
@raviagrawal2862
@raviagrawal2862 12 күн бұрын
Superb explanation in video...
@loveloveonly6964
@loveloveonly6964 12 күн бұрын
is it possible to edit google sheet data from excel sheet ??
@rockfighter9974
@rockfighter9974 14 күн бұрын
You manually filling captcha.so that is not of captcha automation video.
@Klick-s2r
@Klick-s2r 17 күн бұрын
Thanks a ton!
@MANIGI-ub9hi
@MANIGI-ub9hi Ай бұрын
Need to Merge 3 File Path
@parvatlok
@parvatlok 2 ай бұрын
इसमें Initial View tab की properties को set करने को automate किया जा सकता है क्या? मेरे पास बहुत सारी pdfs है जिनकी Initial View properties को सेट करना है पर हो नहीं पा रहा मुझसे
@mukesh22info
@mukesh22info 2 ай бұрын
do we have any option for VBSript for same?
@practicalit91
@practicalit91 2 ай бұрын
Not sure
@MinatiBosu
@MinatiBosu 2 ай бұрын
Would like to contact you for autofill and captcha bypass. Please provide your phone number. We are also sent a mail (reliable)
@MinatiBosu
@MinatiBosu 2 ай бұрын
How to contact you
@practicalit91
@practicalit91 2 ай бұрын
You can write me an email about your project
@andrewbutler7754
@andrewbutler7754 2 ай бұрын
Hello, I get this error when at "WIA_Img.LoadFile Fol_Itm.Path" "Run-time error '-2147024891 (800700005"): Access is denied
@PraveenKumar-il8kn
@PraveenKumar-il8kn 3 ай бұрын
Are you providing VBA trainings?
@practicalit91
@practicalit91 3 ай бұрын
@@PraveenKumar-il8kn what you are looking in vba?
@PraveenKumar-il8kn
@PraveenKumar-il8kn 3 ай бұрын
@@practicalit91 Advanced topics and Web automation
@practicalit91
@practicalit91 2 ай бұрын
@@PraveenKumar-il8kn I can help in your projects instead
@PraveenKumar-il8kn
@PraveenKumar-il8kn 2 ай бұрын
Hi Sir, I need to know how to handle Add sensitivity label in excel.
@MinatiBosu
@MinatiBosu 2 ай бұрын
I want to contact me for captcha bypass and auo fill Please provide your contact number.
@dlin66
@dlin66 3 ай бұрын
Awesome!!! Amazing!!! Easy and effective.!! Thanks!!
@AidziLe-ir7oq
@AidziLe-ir7oq 3 ай бұрын
I do the same but after run macro, no error, but no merge file created. Can you please help me
@practicalit91
@practicalit91 3 ай бұрын
Yes I can help
@swarajemaratha
@swarajemaratha 3 ай бұрын
Just amazing chatgpt and gemini were giving me 50 lines of code, still throwing endless errors. you are amazing Sir
@diegosolano707
@diegosolano707 4 ай бұрын
Hola, cómo puedo ajustar el brillo de una imagen con VBA? Traté de replicar lo indicado en el video para "Quality" pero no funciona Dim img As WIA.ImageFile Dim ip As WIA.ImageProcess Set img = New WIA.ImageFile Set ip = New WIA.ImageProcess img.LoadFile "C:\Users\DMEN\Pictures\Captcha177.jpg" ip.Filters.Add ip.FilterInfos("Convert").FilterID ''ip.Filters.Add (ip.FilterInfos("Brightness").FilterID) ip.Filters(1).Properties("FormatID") = FormatID.wiaFormatPNG ip.Filters(1).Properties("Brightness") = 5 ' Set img = ip.Apply(img) img.SaveFile "C:\Users\DMEN\Pictures ew_image177.PNG"
@munshirasimraja5713
@munshirasimraja5713 4 ай бұрын
Thank u
@uvsubbaiah
@uvsubbaiah 4 ай бұрын
Sir, how can we use a data driven test, like selecting multiple input values from external files.
@farshidfardnian3326
@farshidfardnian3326 4 ай бұрын
How can I use the js code in the first of video for captcha?
@thirupathithiru3319
@thirupathithiru3319 4 ай бұрын
Mail merger Need a specific place in ms word
@chramakanth
@chramakanth 4 ай бұрын
Thank you for this video. I have one question. I have custom date ranges to compare current year vs previous year. For example if I have to compare data from April of one year thru March of other year (12 months) instead of Jan thru Dec. how can we do this
@raghuramsripelli5462
@raghuramsripelli5462 4 ай бұрын
Nice and Good stuff
@AVTJanssens
@AVTJanssens 4 ай бұрын
Hello, nice explanation. It works as long as an element is moved within the screen. When I try to move an element to a place that is off screen, it no longer works. Then what am I doing wrong?
@sauravgupta1607
@sauravgupta1607 5 ай бұрын
Good 👍
@dineshpanihar5863
@dineshpanihar5863 5 ай бұрын
<span aria-hidden="true">₹2065</span> please help to scrap the price
@practicalit91
@practicalit91 5 ай бұрын
Which website?
@practicalit91
@practicalit91 5 ай бұрын
Sub CreateDigitalSignature() Dim Acro_App As Acrobat.AcroApp Dim Acro_PDdoc As Acrobat.AcroPDDoc Dim Ojs As Object Dim SGH_Ppklite As Object Dim Signature_Coord() As Variant Dim SignField As Object Dim ppklite_login Dim Getsignfield As Object Dim OinforArray() As String Dim Signdone As Boolean Const Bottom_Left_x = 100 Const Bottom_Left_y = 100 Const Wdth = 100 Const Hght = 60 Signature_Coord = Array(Bottom_Left_x, Bottom_Left_y + Hght, Bottom_Left_x + Wdth, Bottom_Left_y) Set Acro_App = New Acrobat.AcroApp Set Acro_PDdoc = New Acrobat.AcroPDDoc If Acro_PDdoc.Open("C:\Users\Sunil Kumar\OneDrive\Desktop\Sign.pdf") Then Set Ojs = Acro_PDdoc.GetJSObject Set SGH_Ppklite = Ojs.security.getHandler("Adobe.PPKLite") Set SignField = Ojs.addfield("MysignField", "signature", 0, Signature_Coord) 'Lets Login ppklite_login = SGH_Ppklite.login("sign@123", "C:\Users\Sunil Kumar\AppData\Roaming\Adobe\Acrobat\11.0\Security\Sk.pfx") 'Mention time out SGH_Ppklite.setpasswordtimeout "sign@123", 200 ' Get signature field reference Set Getsignfield = Ojs.getfield("MysignField") OinforArray = VBA.Split("", ",") 'Sign the signature Field Signdone = Getsignfield.signaturesign(SGH_Ppklite, OinforArray, "C:\Users\Sunil Kumar\OneDrive\Desktop\SignTest.pdf") 'Last Step Logout SGH_Ppklite.logout End If End Sub
@sauravpalakkeel7455
@sauravpalakkeel7455 5 ай бұрын
Can you share the vba code please
@practicalit91
@practicalit91 5 ай бұрын
Copy the code from comment section of the video
@twinklebatham1725
@twinklebatham1725 5 ай бұрын
Thank you so much✨ Beautifully explained and now I'm confident to use it
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
In video VBA - Captcha Automation Part-2 (Selenium VBA). If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 5 ай бұрын
If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@practicalit91
@practicalit91 5 ай бұрын
Please use goto: statement above inputbox
@tpdakc7904
@tpdakc7904 5 ай бұрын
@@practicalit91 Can you make a tutorial video?please
@tpdakc7904
@tpdakc7904 5 ай бұрын
If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 6 ай бұрын
If captcha code is incorrect then how can i pop up again input box. Make video tutorial, please
@tpdakc7904
@tpdakc7904 6 ай бұрын
If captcha code is incorrect then how can i pop up again input box.
@vishal-sp5cw
@vishal-sp5cw 6 ай бұрын
Sir mere computer ke excel pr toh selinium type library show hi nhi hoti?
@practicalit91
@practicalit91 6 ай бұрын
Please watch this first kzbin.info/www/bejne/pKXceK2hjrSeqK8
@shaileshsharma668
@shaileshsharma668 6 ай бұрын
I have question I want to interact with the web application which page is already open by manual
@practicalit91
@practicalit91 6 ай бұрын
Research is still on
@practicalit91
@practicalit91 6 ай бұрын
Dim CD As Selenium.ChromeDriver Sub JS_Example_2ndMethod() Set CD = New Selenium.ChromeDriver With CD .Get "" .Window.Maximize End With Dim jscode As String 'This line defines JavaScript code that prompts the user to enter their name using the window.prompt() method. jscode = "var userInput = window.prompt('Please enter your name:');" & vbCrLf 'This line appends JavaScript code to create a new <div> element jscode = jscode & "var divElement = document.createElement('div');" & vbCrLf 'This line appends JavaScript code to set the id attribute of the <div> element jscode = jscode & "divElement.id = 'userInputDiv';" & vbCrLf 'This line appends JavaScript code to create a text node containing the message jscode = jscode & "var textNode = document.createTextNode(userInput);" & vbCrLf 'This line appends JavaScript code to append the text node to the <div> element. jscode = jscode & "divElement.appendChild(textNode);" & vbCrLf 'This line appends JavaScript code to append the <div> element to the body of the document jscode = jscode & "document.body.appendChild(divElement);" 'execute javascript code CD.ExecuteScript jscode 'define variables for timeout and loop interval Dim timeoutsec As Integer timeoutsec = 50 Dim Millisec As Integer Millisec = 500 'wait for user input and loop Dim userinput As String Dim starttime As Double starttime = Timer Do 'check if the userimputdev element exists On Error Resume Next userinput = CD.FindElementById("userInputDiv").Text On Error GoTo 0 'if userinput is not empty or timeout is reached,exit loop If userinput <> "" Or Timer - starttime > timeoutsec Then Exit Do Application.Wait Now + TimeValue("0:00:01") Loop CD.Quit Msgbox userinput End Sub
@lucasdab6688
@lucasdab6688 6 ай бұрын
Epic. You are master! I've a question about what should be modified to search for text such as 125/6. I turned off checking whether the value being searched for is a number in the code, but it finds 125 without /6. Same thing with the time 19:55 - it finds 19 or 55 separately. It doesn't see 19:55. What should be modified to find data of the 125/6 type?
@practicalit91
@practicalit91 6 ай бұрын
Currently this macro is designed to search for string text to give accurate results. Searching numbers may give undesired output.
@prasenjitmandal5486
@prasenjitmandal5486 6 ай бұрын
Very useful
@mahbubalam56199
@mahbubalam56199 6 ай бұрын
Hello Dear, Its possible to share the source file....so i can practice it and then learn it... Thamks, Mahbub BD
@sidharthpattanayak1066
@sidharthpattanayak1066 6 ай бұрын
Very nice video At 04:22 where the user input value is displayed?