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
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.
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
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 🌺🌺
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
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
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
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
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.
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
@@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
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.
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 🌺🌺
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
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.
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.
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.
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
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
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
th-cam.com/video/B6xSOfSMrRI/w-d-xo.html 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 🙏🙏🙏🙏🙏🙏
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?
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
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 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
Thanks!
Welcome and thank you ❤️
🙏👍👏You are really "Magican of excel VBA"
Very helpful method and code
Thank you so much
Welcome and thank you for your like and share it help us
Super - Excellent Video - Im grateful.
GREAT TEACHER AND GENIOUS MAN YOU ARE !
THANKS SIR 🌺🌺
Thank you and i appreciate keep watching
Very Good Teacher
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
Very very useful and interesting video sir
Good concept nice trick
Thank you
Thank you for your support
Tons of likes and thanks..Sir🥰😇
I appreciate thank you for your like and share it help us
Good concept. And nice trick
Thank you ❤️
That is amazing. Thanks for the share.
I appreciate, please share this video to help us
you are genius sir
Nice video sir.
Thank you
Sir, U R really appreciated person. Plz sir, create project for sending payslip via telegram app/software?
Yes I will try and upload very soon
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.
Thank you for your comments first off all of your want only one salary slip sent then remove look and give there a criteria
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
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
Sir , me also waiting for solution@@vbAFun
very nice
Great work how can send slip in difference numbers
You can use same method for that
salary slip and attendance starting se step by step link bhej dijiye kuch samajame nahi aaya kidhar se start karna bahut acha banaya hai
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
Thanks, Sir
Sir mera ak question hay kya may app say bat kar saka hu
Sir AAP jaisa knowledge ke liye kiya kare please replayme
Sir iske liye practice kare
Nice coment
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 🌺🌺
Microsoft Excel is waiting for another application to complete an OLE action errro aa rhaa h how to solve sir
Sir very nice video. Sometime it is working and sometime not. Is there any restrictions. Pls advice
Please wait i will upload video this Thursday
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
Very Nice & useful video Sir. Sir slips are being sent to my own number only & not able to send other numbers.. what to do?
Sir, whatsapp "group" me vba form se kese festivals msg kar sakte hai, kuch unique banaiye sir plz.
Isko check karna hoga ki kaise kar sakte hai question unique hai mai try karta hun
Amazing
Thank you
@@vbAFun welcome
Can you tell me
Image ko userform sy excel sheet me kasy save kr skty hn
Employees k name k sath hi pictures b save hu sheet me hi ?
I think maine uske liye method bata rakha hai how to generate QR. Ode bale me same method aap use kar sakte ho
@@vbAFun thkns I'll be try
I have tried now but fail
Variable not found ata hai
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
Sir Not Run this Code. Plese Help
Ajay Sir,
Is it possible to Salary Slip as a pdf to every memeber over the WhatsApp..?
Yes it is possible I have already uploaded video to send file as attachment on whatsapp
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
Once you allow them also check the box for future notification
No check box is here sir only permission allow and cancel option
And regularly show on desktop screen for permission
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
Sir
Google Chrome me WhatsApp Ho ga Kiya
Haan kyu nahi but uske liye apko additional Libra use karna hoga
Respected Sir
me edge use karta hu usame next time allow dena padta hai please crome ka video banaye
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
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
hi sir your sheet is best working ..... please discription me iska link nahi h download ka please provide this sheet link ....thanks sir
File Updated
@@vbAFun please share me link your sheet please
Can you share the excel sample file with the VBA Script used in this? Unable to find it ...
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
Sir 1 excel or google sheet se whatsapp message kaise bheje please make a simple video for the same
Hello Sir,
Could you provide the video link please if possible.
I made a another video ont that recently please visit channel and check
Sir ek video
book issue and return par banaye
pleases sir
LIBRARY MANAGEMENT HO NA HAI
Please, Help me
I want run this program but image do not able to copy & paste in WhatsApp by code.
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.
No it will send to all employees you need to run loop as i said in video
Sir, koi data WhatsApp group pe kaise bhej sakte hain
Us code pe mai kam kar raha hun jab ban jayega to sure mai share karunga
Sir
Selenium chrome driver se kaise karein same bata doo
Okay wait will upload in future video
Very nice👌
But text was not going in video
Oh okay I have to check when I made that was working perfectly I think I have missed that
Sir, Can you please share the file link for further support, Thanks
Please check the latest video description on that
Thanku Sir
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
And before use MS OFFICE 2007 now 2019
If you r using windows what's app then there is some issue
@@vbAFun problem just in
Application.sendkey
Sir ye kam nahe kar raha hy
@@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
Har member ko alag alag uski sellery sleep kaise send kore?
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
Ek bar aap internet explorer ko default set kar do
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.
Hi please check description to download the file
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 🌺🌺
Hi thank you for your comment, this is whatsapp app which you use on desktop
@@vbAFun
Thanks Dear Sir 🌺🌺
GOD BLESS YOU 🌺🌺
THANKS 🌺🌺
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 ???
Yes if you using internet explorers then yes
Sir
Please share the code for "Generate and email"
Watch this video and check description
th-cam.com/video/L2GFDU8iCbc/w-d-xo.html
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.
Use same method for your requirement
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
Sir how to send on group
I want send in group
Idea is good will show in future video
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.
Please wait I will upload with new trick for this
Sir please send me your prepared Excel file which is shown in this video
Now a day this method is not working will upload anothe video with some different me hod for that
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.
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.
Restart the system and check again same problem hai to dubara se office install kare
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
Can you connect me on instagram
@@vbAFun drop ur contact number directly also insta id
Sir its asking everytime "allow to yes" what to do
You have to check your windows permission
Applying same codding is not working. Message is not appearing.
Please check with runing code step by step
❤
in windows 10 and office 365 it is not working. Please suggest
For this I made a recently video please watch that, I also used 365
Can we send whatsapp mess to group also ?
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
Hi please watch full video I have given two method in this video
@@vbAFun I try both method but fail .......... and also i watch full video many time ...
This type of problem should not happened but if there is still problem then i have to see for what is the exact problem.
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
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
Sir allow karne ke bad bhi har ek slip bhejne ke liye dobara message box ajaata h ki allow or cancel again and again
Allowbox aaye to oha pe ek checkbox bhi aa raha hoga use check kar de
@@vbAFun Not coming
Reinstall again
Earning ✔Correcct Spellings "Eearning"❌
Thank you 👍 for correct me
Sir how to send to existing whatsapp group
I have not try for that thank you for you suggestion will try and upload if i made
Sir please explain this video in english 😢
Sir text automatically type nahi ho raha sirf picture bann ke send ho raha hai
Aisa nahi hona chahiye please step ko asche se dekhe aur jarurat pade to wait time badha dijiye
Run error
Lastrows
Internet explorer has been depricated by Microsoft. It is not going to work longer. Show us how to use chrome browser for the same
Idea is good will try to create a separate video
Also I need sir
Thank yes will create a video on this
can you share the code.
Very good sir ..! Can you show us sent by telegram pls ?❤
Do you want same thing on telegram, good idea will try
@@vbAFun yes sir I’m waiting ur video ..! Thank you reply
Hi lida thank you for your comments, can I ask one thing that are you understand my explaining method
@@vbAFun yes sir For English is ok but ur languages I’m not .. I’m try to understand ur show step by step 🥰
Sir compile error aa rha hai ke
Sub or Function not defined
Please sir help me out
Please check code apne sub procedure run karaya hai kisi procedure ke andar to ye error aayega
@@vbAFun starting mein he error h yellow highlight ho jata
Please solution
@@vbAFun sir mobile no. Provide kar doo
Apse discuss kar longa jo bhi fees ho gee le lena
Kis jagah pe aa raha hai video ko pura dekhe aur us method ko follow kare
@@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
please provide code in description
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
i need your sheet
you can download from the description
Iske sath text nhi Jaa Raha hai sir
Ab whatsapp ka windows app aa gaya hai to uske liye coding ko change karna hoga
@@vbAFun ok solution mil gya apki dusri video se
Thanks
Please share file with code
Okay will upload please try to make yourself by watching this video it will help you
how to download sample file
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
@@vbAFun ok but sir in excel data require i put code it
please..............? provide code vba
Please check description
Sir please explain this video in English
Hi mster can you please send me the file
This is very simple line of code u can write easily
th-cam.com/video/B6xSOfSMrRI/w-d-xo.html
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 🙏🙏🙏🙏🙏🙏
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?
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
Code send kar do
Very small code please watch video
Bro i have bill excel format.in the bill share what's app number send for customer number
Yes that can be done using excel vba
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
Hi code is fine, check is there any permission asking for sending msg ise alt + tab to check
@@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
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
Or please wait i will try to upload video on this thirsday
@@vbAFun 🙏OK, Sir
sir, please response on Instagram.
I have not received msg yet