🙏👍👏You are really "Magican of excel VBA" Very helpful method and code Thank you so much
@vbAFun2 жыл бұрын
Welcome and thank you for your like and share it help us
@ChiduItsme Жыл бұрын
Its Superb!!! its fantastic!!! i am searched many websites but i didn't get a proper trick once i saw your video of salary slip sent through WhatsApp by seeing only it looks wow an easy method and i tried it, all ok and WhatsApp also getting open but the image and that text is not copying and sending you mentioned two different code i tried both but its not coming can you help me out
@shahqasim8513 Жыл бұрын
GREAT TEACHER AND GENIOUS MAN YOU ARE ! THANKS SIR 🌺🌺
@vbAFun Жыл бұрын
Thank you and i appreciate keep watching
@FawwadSiddiquie2 ай бұрын
Super - Excellent Video - Im grateful.
@mohanbalodia3060 Жыл бұрын
Very Good Teacher
@annabathulavekatagovindara88832 жыл бұрын
Good concept nice trick Thank you
@vbAFun2 жыл бұрын
Thank you for your support
@financeforyou7425 Жыл бұрын
Sir very nice video. Sometime it is working and sometime not. Is there any restrictions. Pls advice
@vbAFun Жыл бұрын
Please wait i will upload video this Thursday
@Suhask115 ай бұрын
Very very useful and interesting video sir
@pintuchoyan95262 жыл бұрын
Sir how can send separate salary slip to separate employees by WhatsApp just one click . Please share code or modify code. U r VBA MAGICIAN. U R UNIQUE VBA PROGRAMMER.
@vbAFun2 жыл бұрын
Thank you for your comments first off all of your want only one salary slip sent then remove look and give there a criteria
@SanviPatil2019 Жыл бұрын
Sir mujhe har ek employee ko uski hi salary slip bhejani hai.. kaise bheje.. apka Diya huva VBA code work nahi kar raha hai.. Mere sheet me ८२ employee hai.. net salary column ke baad Mobile number ka column hai.. ab me pay slip ki sheet me vlookup ke through us employee ka mobile number laya hai.. jab code run karta hu to . Employee ki pay slip aur mobile number change nahi ho raha hai.. ek hi number par slip send ho rahi hai.. kabhi kabhi internet explorer object ke pass code ruk Raha hai
@vbAFun Жыл бұрын
Haan abhi whatsapp ne kusch change Kiya hai jisse ki ab problems aa rahe hai mai usko check kar raha hun kaise resolved kar sakte hai
@asifaasi47352 ай бұрын
Sir , me also waiting for solution@@vbAFun
@pdqmr102 жыл бұрын
Sir, U R really appreciated person. Plz sir, create project for sending payslip via telegram app/software?
@vbAFun2 жыл бұрын
Yes I will try and upload very soon
@anshumangaikwad9850 Жыл бұрын
Very Nice & useful video Sir. Sir slips are being sent to my own number only & not able to send other numbers.. what to do?
@veeranjikumar60972 жыл бұрын
Good concept. And nice trick
@vbAFun2 жыл бұрын
Thank you ❤️
@jajraj10 ай бұрын
Thanks, Sir Sir mera ak question hay kya may app say bat kar saka hu
@elija_ed_vann2 жыл бұрын
Tons of likes and thanks..Sir🥰😇
@vbAFun2 жыл бұрын
I appreciate thank you for your like and share it help us
@shahqasim8513 Жыл бұрын
Hi Respected Sir ! Meri aik request hei , kindly aap k pass jb b time ho , to kindly Sir ! , aap is hee video k ander thori editing kr k btayn , k ager in hi employees k phone number code k ander likh dien , aur in hee employees ko in ki salary slip send ho jaye , whats app k through ? Aur secondly computer sy jo whatsapp send ho ga , to computer mein whatsapp install krna ho ga , ya kaya cheez honi chahiyay , computer k ander , jis k through whatsapp send ho ga , Thanks alot Dear Sir ! Thanks 🌺🌺
@amiyplacement71502 жыл бұрын
Ajay Sir, Is it possible to Salary Slip as a pdf to every memeber over the WhatsApp..?
@vbAFun2 жыл бұрын
Yes it is possible I have already uploaded video to send file as attachment on whatsapp
@intakhabkhan96492 жыл бұрын
Nice video sir.
@vbAFun2 жыл бұрын
Thank you
@anjankumarsahu9516 Жыл бұрын
Sir Google Chrome me WhatsApp Ho ga Kiya
@vbAFun Жыл бұрын
Haan kyu nahi but uske liye apko additional Libra use karna hoga
@SyedMuzammilMahasanShahi2 жыл бұрын
That is amazing. Thanks for the share.
@vbAFun2 жыл бұрын
I appreciate, please share this video to help us
@prasadbhaste9067 Жыл бұрын
salary slip and attendance starting se step by step link bhej dijiye kuch samajame nahi aaya kidhar se start karna bahut acha banaya hai
@tech11.7863 ай бұрын
Sir code running k samay what's up khulne se pahle permission kiyu magta hai jaise. (Do you want to allow this website to open an app to your computer )is ko kaise fix kare
@nEcTArsTha Жыл бұрын
you are genius sir
@NoorAli-qs2lb Жыл бұрын
Hello Sir, please reply with a code for WhatsAppweb I want to send it using WhatsApp web. Will this code work for WhatsAppWeb as well ???
@vbAFun Жыл бұрын
Yes if you using internet explorers then yes
@kamraniqbal60582 жыл бұрын
Great work how can send slip in difference numbers
@vbAFun2 жыл бұрын
You can use same method for that
@kailashsoni676 Жыл бұрын
Sir make a video on how to link excel with Google sheet online database If we do entry into userform thn data load into Google sheet
@hariom3672 Жыл бұрын
Sir Not Run this Code. Plese Help
@shahqasim8513 Жыл бұрын
Hi Dear Sir 🌺 Kindly give a sweet reply , my question is only that what is the name of this whatsapp application on which these salary slips are sent . Whatsapp desktop or any other app , Thanks my Dear Sir 🌺🌺
@vbAFun Жыл бұрын
Hi thank you for your comment, this is whatsapp app which you use on desktop
@shahqasim8513 Жыл бұрын
@@vbAFun Thanks Dear Sir 🌺🌺 GOD BLESS YOU 🌺🌺 THANKS 🌺🌺
@pinkeshjain.tutorofaccount2288 Жыл бұрын
do you want to allow this website to open an app on your computer allow? This dialogue box open in desktop screen for whatsapp permission how to solve this problem
@vbAFun Жыл бұрын
Once you allow them also check the box for future notification
@pinkeshjain.tutorofaccount2288 Жыл бұрын
No check box is here sir only permission allow and cancel option
@pinkeshjain.tutorofaccount2288 Жыл бұрын
And regularly show on desktop screen for permission
@vbAFun Жыл бұрын
Where you allowing you will see above and some left size a textbox and if not showing then then you have to give permission with properties
@KundanFluteArt2 жыл бұрын
Sir, whatsapp "group" me vba form se kese festivals msg kar sakte hai, kuch unique banaiye sir plz.
@vbAFun2 жыл бұрын
Isko check karna hoga ki kaise kar sakte hai question unique hai mai try karta hun
@aravindreddy9737 Жыл бұрын
Thanks!
@vbAFun Жыл бұрын
Welcome and thank you ❤️
@tech11.7865 ай бұрын
Sir AAP jaisa knowledge ke liye kiya kare please replayme
@vbAFun5 ай бұрын
Sir iske liye practice kare
@tech11.7865 ай бұрын
Nice coment
@DEVENDRAJORWAL-s2o10 ай бұрын
hi sir your sheet is best working ..... please discription me iska link nahi h download ka please provide this sheet link ....thanks sir
@vbAFun10 ай бұрын
File Updated
@DEVENDRAJORWAL-s2o10 ай бұрын
@@vbAFun please share me link your sheet please
@devbaraiya8984 Жыл бұрын
Respected Sir me edge use karta hu usame next time allow dena padta hai please crome ka video banaye
@trickysportsbesttricks73836 ай бұрын
very nice
@UdayChande-h5k Жыл бұрын
Can you share the excel sample file with the VBA Script used in this? Unable to find it ...
@vbAFun Жыл бұрын
I think file has given in description also I want to let u know that now this code is oot working properly due to change in whatsapp
@anumqueen8759 Жыл бұрын
Hello sir thanks for this vedio I use this micro in my vba form Before I use window7 it work properly but last night i install window 10 now vba copy my slip but don't paste and don't send
@anumqueen8759 Жыл бұрын
And before use MS OFFICE 2007 now 2019
@vbAFun Жыл бұрын
If you r using windows what's app then there is some issue
@anumqueen8759 Жыл бұрын
@@vbAFun problem just in Application.sendkey Sir ye kam nahe kar raha hy
@anumqueen8759 Жыл бұрын
@@vbAFun 1) Whatsapp app open hota hy 2) jo number cell may hota hy os k sat auto +92 ata hy 3) pir Whatsapp my os ki chat open hota 4) Jo message micro my lika hy " Thanks etc" Yaha tak kam hota hy Likn os k bad Whatsapp py picture paste our khod send nahe hota
@bivaybabu5411 Жыл бұрын
Hello Sir, Could you provide the video link please if possible.
@vbAFun Жыл бұрын
I made a another video ont that recently please visit channel and check
@user-th3hf9lr2l2 жыл бұрын
sir, suppose ki A tradrs, B trdaers, C traders aur bhi party hai.magar main chahatahu ki party ke name pe click karnese party wise userform party ke detail ke sath change hota rahe aur add save update delete savi kam karta rahe.es prakar ka userfiom kaise banaskte hain please eske upar kam kare. thank you
@vbAFun2 жыл бұрын
Yes kiya ja sakta hai isme login ka use karke traders wise kam kar sakte hai. Aur aap super advance data entry ka video dekh sakte hai iske liye
@dpsinger790 Жыл бұрын
Sir, koi data WhatsApp group pe kaise bhej sakte hain
@vbAFun Жыл бұрын
Us code pe mai kam kar raha hun jab ban jayega to sure mai share karunga
@Akhileshvishwakarma5645 ай бұрын
Microsoft Excel is waiting for another application to complete an OLE action errro aa rhaa h how to solve sir
@bhavneshparikh82832 жыл бұрын
Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest
@llnowledge8144 Жыл бұрын
Sir please help me, Sir I am Tamil medium, so I can't able to get your video if you explain in english it will be helpful to me, in this Excel where we enter the client phone number to send message to client, sir I didn't see any phone number mentioned in this Excel sheet, sir please explain me , and also I want your prepared Excel file which is shown in this video, sir this is my kind request.
@vbAFun Жыл бұрын
Please wait I will upload with new trick for this
@aqeelahmad17642 жыл бұрын
Amazing
@DiwakkarJnawali10 ай бұрын
Sir 1 excel or google sheet se whatsapp message kaise bheje please make a simple video for the same
@HamzaAli-gg4fy Жыл бұрын
Sir, Can you please share the file link for further support, Thanks
@vbAFun Жыл бұрын
Please check the latest video description on that
@HamzaAli-gg4fy Жыл бұрын
Thanku Sir
@mathematicsclasseasyway92502 жыл бұрын
Sir ek video book issue and return par banaye pleases sir
@hasmukhnirmal12632 жыл бұрын
LIBRARY MANAGEMENT HO NA HAI
@rajeshbhosle51322 жыл бұрын
Userform main dependant list box kaise banaye or listbox main 10 workbook ke sheets ka data listbox main kaise laye or userform se data kisi alag workbook main kaise save kare
@Marcus-jh7lg Жыл бұрын
Hi, I really like this video which allow copy a cell range in excel and paste onto WhatsApp and send out. Unfortunate, I cannot understand the language, wonder you have a translated version and can I download the source code. I was trying with out success to just copy a range cell in excel to WhatsApp. Can you please help. Thanks in advance.
@vbAFun Жыл бұрын
Hi please check description to download the file
@subodhkushwaha11 Жыл бұрын
Doy you want to allow this website to open an app on your computer? aisa msg aata hai, bar bar nhi aaye iska koi upay bata djiye
@vbAFun Жыл бұрын
Ek bar aap internet explorer ko default set kar do
@dilipsarda4u2 жыл бұрын
Very nice👌 But text was not going in video
@vbAFun2 жыл бұрын
Oh okay I have to check when I made that was working perfectly I think I have missed that
@jaiprakashmahawar7236 Жыл бұрын
Sir how to send on group I want send in group
@vbAFun Жыл бұрын
Idea is good will show in future video
@imransayyed44618 ай бұрын
i have a requirement, if you can help me to get the VB code for it, its society monthly bills, we can discuss on the payment
@vbAFun8 ай бұрын
Can you connect me on instagram
@imransayyed44618 ай бұрын
@@vbAFun drop ur contact number directly also insta id
@bivaybabu5411 Жыл бұрын
in windows 10 and office 365 it is not working. Please suggest
@vbAFun Жыл бұрын
For this I made a recently video please watch that, I also used 365
@nihal275011 ай бұрын
Sir Selenium chrome driver se kaise karein same bata doo
@kunalbose10756 ай бұрын
❤
@babasonk2 жыл бұрын
Sir Please share the code for "Generate and email"
@vbAFun2 жыл бұрын
Watch this video and check description kzbin.info/www/bejne/gmOqd3eLbc52mMU
@babasonk2 жыл бұрын
Thank you very much sir. Kindly upload the video to send the pdf files which are already in the D drive to employees throgh Excel database.
@vbAFun2 жыл бұрын
Use same method for your requirement
@HamzaAli-gg4fy Жыл бұрын
Sir can it is possible to send slip to all staff on thier whatsapp number can we link the mobile number in it. because current scrit send the slip only the open chat.
@vbAFun Жыл бұрын
No it will send to all employees you need to run loop as i said in video
@llnowledge8144 Жыл бұрын
Sir please send me your prepared Excel file which is shown in this video
@vbAFun Жыл бұрын
Now a day this method is not working will upload anothe video with some different me hod for that
@llnowledge8144 Жыл бұрын
Sir I am Tamil medium, so I can't able to get your video, in this Excel where we enter the client phone number to reach them, sir I didn't see any phone number mentioned in this Excel sheet, sir please explain me, and also I want your prepared Excel file which is shown in this video, sir this is my kind request.
@nihal2750 Жыл бұрын
Sir code run karne parr bar bar message box open hota hai ki do you want following application to allow or not (whatsapp) open hone ke liye ,Message box internet explorer ka hota hai
@vbAFun Жыл бұрын
Haan ye ek bar aap usko allow karke oha pe ek checkbox hoga use tick kar de aur ye sab hamne video me bata rakha hai
@nihal2750 Жыл бұрын
Sir allow karne ke bad bhi har ek slip bhejne ke liye dobara message box ajaata h ki allow or cancel again and again
@vbAFun Жыл бұрын
Allowbox aaye to oha pe ek checkbox bhi aa raha hoga use check kar de
@nihal2750 Жыл бұрын
@@vbAFun Not coming
@vbAFun Жыл бұрын
Reinstall again
@abuhammad8652 Жыл бұрын
Har member ko alag alag uski sellery sleep kaise send kore?
@syedshahzaibali4729 Жыл бұрын
Can we send whatsapp mess to group also ?
@wanderer_sky__ Жыл бұрын
Sir how to send to existing whatsapp group
@vbAFun Жыл бұрын
I have not try for that thank you for you suggestion will try and upload if i made
@AM-jd3rs2 жыл бұрын
Sir my excel File is not open. showing excel file has not working. How to solve it. Sir please reply. I am prepare Excel VBA software. But now it not open.
@vbAFun2 жыл бұрын
Restart the system and check again same problem hai to dubara se office install kare
@anilkumarsharma5439 Жыл бұрын
Applying same codding is not working. Message is not appearing.
@vbAFun Жыл бұрын
Please check with runing code step by step
@aravindans65115 ай бұрын
Sir its asking everytime "allow to yes" what to do
@vbAFun5 ай бұрын
You have to check your windows permission
@PinkalPrajapati-ue1wd7 ай бұрын
Please, Help me I want run this program but image do not able to copy & paste in WhatsApp by code.
@chhoenlida2 жыл бұрын
Very good sir ..! Can you show us sent by telegram pls ?❤
@vbAFun2 жыл бұрын
Do you want same thing on telegram, good idea will try
@chhoenlida2 жыл бұрын
@@vbAFun yes sir I’m waiting ur video ..! Thank you reply
@vbAFun2 жыл бұрын
Hi lida thank you for your comments, can I ask one thing that are you understand my explaining method
@chhoenlida2 жыл бұрын
@@vbAFun yes sir For English is ok but ur languages I’m not .. I’m try to understand ur show step by step 🥰
@afrinsir74792 жыл бұрын
please provide code in description
@vbAFun2 жыл бұрын
Thank you for your comment, I have already share a code in salary slip generation video in this video has one some line change request to please pause the video and modify the code as per your requirement
@nihal2750 Жыл бұрын
Sir text automatically type nahi ho raha sirf picture bann ke send ho raha hai
@vbAFun Жыл бұрын
Aisa nahi hona chahiye please step ko asche se dekhe aur jarurat pade to wait time badha dijiye
@llnowledge8144 Жыл бұрын
Sir please explain this video in english 😢
@KaranSingh-mg2cp2 жыл бұрын
Internet explorer has been depricated by Microsoft. It is not going to work longer. Show us how to use chrome browser for the same
@vbAFun2 жыл бұрын
Idea is good will try to create a separate video
@pintuchoyan95262 жыл бұрын
Also I need sir
@vbAFun2 жыл бұрын
Thank yes will create a video on this
@firozhossen14852 жыл бұрын
can you share the code.
@llnowledge8144 Жыл бұрын
Sir please explain this video in English
@nihal2750 Жыл бұрын
Sir compile error aa rha hai ke Sub or Function not defined Please sir help me out
@vbAFun Жыл бұрын
Please check code apne sub procedure run karaya hai kisi procedure ke andar to ye error aayega
@nihal2750 Жыл бұрын
@@vbAFun starting mein he error h yellow highlight ho jata Please solution
@nihal2750 Жыл бұрын
@@vbAFun sir mobile no. Provide kar doo Apse discuss kar longa jo bhi fees ho gee le lena
@vbAFun Жыл бұрын
Kis jagah pe aa raha hai video ko pura dekhe aur us method ko follow kare
@nihal2750 Жыл бұрын
@@vbAFun pura dekh liya phir bhi error aa ra h. apka joo practice file download kiya mene aur apne laptop me chalya uss me bhi same error h
@amjadansaree2 жыл бұрын
i try but not work ................. only open my whatsApp and sending whatsApp Name or mobile number display, but no image and no text massage show on that person
@vbAFun2 жыл бұрын
Hi please watch full video I have given two method in this video
@amjadansaree Жыл бұрын
@@vbAFun I try both method but fail .......... and also i watch full video many time ...
@vbAFun Жыл бұрын
This type of problem should not happened but if there is still problem then i have to see for what is the exact problem.
@bhavneshparikh82832 жыл бұрын
how to download sample file
@vbAFun2 жыл бұрын
I have used very simple code to write simply pause the video and write the code it will help you to learn and build your logic
@bhavneshparikh82832 жыл бұрын
@@vbAFun ok but sir in excel data require i put code it
@DEVENDRAJORWAL-s2o10 ай бұрын
i need your sheet
@vbAFun10 ай бұрын
you can download from the description
@pintuchoyan95262 жыл бұрын
Please share file with code
@vbAFun2 жыл бұрын
Okay will upload please try to make yourself by watching this video it will help you
@kailashsoni676 Жыл бұрын
Iske sath text nhi Jaa Raha hai sir
@vbAFun Жыл бұрын
Ab whatsapp ka windows app aa gaya hai to uske liye coding ko change karna hoga
@kailashsoni676 Жыл бұрын
@@vbAFun ok solution mil gya apki dusri video se Thanks
@anandsharma61024 ай бұрын
Run error Lastrows
@DEVENDRAJORWAL-s2o10 ай бұрын
please..............? provide code vba
@vbAFun10 ай бұрын
Please check description
@muhammadnaumanaslam296211 ай бұрын
Earning ✔Correcct Spellings "Eearning"❌
@vbAFun11 ай бұрын
Thank you 👍 for correct me
@Tecnical-Eng-PLC Жыл бұрын
Hi mster can you please send me the file
@vbAFun Жыл бұрын
This is very simple line of code u can write easily
@gobindghadai90652 ай бұрын
Code send kar do
@vbAFun2 ай бұрын
Very small code please watch video
@akbhandari2001 Жыл бұрын
Sir, the code is continuously showing error at "Set Browser = CreateObject ("InternetExplorer.Application") Is there any way to shoot message directly through whatsapp's windows app as Internet Explorer is to be discontinued?
@vbAFun Жыл бұрын
Yes now the whatsapp is available in windows app that is why there is issue i m trying to find out other way or you use api but api should be purchased from whatsapp
@mathematicsclasseasyway9250 Жыл бұрын
kzbin.info/www/bejne/eGfbhIKciLKliKs Sir ye library management ka video hai inky language hamen samajh mein nahin a Rahi kya aap ise Hindi mein bana kar ke upload kar sakte hain 🙏🙏🙏🙏🙏🙏
@mrgk36866 ай бұрын
Bro i have bill excel format.in the bill share what's app number send for customer number
@vbAFun6 ай бұрын
Yes that can be done using excel vba
@nEcTArsTha Жыл бұрын
sir, please response on Instagram.
@vbAFun Жыл бұрын
I have not received msg yet
@uznabee1 Жыл бұрын
Thanks a lot Ajay, Sir for extending a helping hand to learn Excel-VBA. After seeing this video, I tried to send msg on Whatsapp, but could not successful. The VBA codes used by me are as follows : Sub SendSlip() Application.Visible = False 'LastRow = Sheet2.Range("E" & Rows.Count).End(xlUp).Row 'For EmpRow = 14 To 18 Step 4 With Sheet2 '.Range("E7") = Sheet2.Range("E" & EmpRow) '.Range("E6") = Sheet2.Range("E" & EmpRow - 1) Set Browser = CreateObject("InternetExplorer.Application") 'Mob = "+91" & Range("A1") Mob = "+91xxxxxxxxxx" Browser.Navigate "whatsapp://send?phone=" & Mob & "& Text=Happy New Year 2023" '.Range("B9:E22").Copy '.Range("g5:m22").Copy .Range("B9:E22").CopyPicture xlScreen, xlBitmap '.Range("G5:M22").CopyPicture xlScreen, xlBitmap Application.Wait Now + 0.00005 Application.SendKeys "^v" Application.Wait Now + 0.00003 Application.SendKeys "~" Application.Wait Now + 0.00003 End With 'Next EmpRow Application.Visible = True End Sub With above codes, Whatsapp is opening but message is not going. 🙏Would be greatful for your guidance to find out where i had done mistake. Regards
@vbAFun Жыл бұрын
Hi code is fine, check is there any permission asking for sending msg ise alt + tab to check
@uznabee1 Жыл бұрын
@@vbAFun Sir, Thanks a lot, I am really grateful to you as I had never expected that I will get response from your side so quick. Sir that comes up and Whatsapp gets open but msg is not going. Regards
@vbAFun Жыл бұрын
I mean in the whatsapp when u open from automation then window intrupt and asking for a permission so please check that i also show in video
@vbAFun Жыл бұрын
Or please wait i will try to upload video on this thirsday