Send Salary Slip on WhatsApp in Image Format using Microsoft Excel Vba | Excel Application
Рет қаралды 27,813
Жыл бұрынSend Salary Slip on WhatsApp in Image Format using Microsoft Excel Vba and send range as image on whatsapp
This video helps you to send WhatsApp message from Excel using excel vba, You Can use this method to create your own excel application for automation of Whatsapp.
Download Free File : drive.google.com/file/d/1I3Ja...
Join this channel to get access to perks:
===============================
/ @vbafun
===============================
About Excel vba
=================================
Excel VBA is a very useful programming language where you can do your work very smartly and this language is very simple to use. From this channel, you will learn how to simplify your code in excel VBA to automate your sheet for daily routine work as well as will teach you how to create an application in excel VBA to make the data entry, invoice, keeping a record of data inventory and many more excel application which uses in each and every offices and school.
=================================
Our Aim to Develop Skill in Excel :
=============================
userform in excel in hindi
excel vba training
excel application development
simple method to writing code
excel micros
userform automation
excel sheet automation
Free sample excel application
=============================
Never Seen Before Playlist in Excel Vba :
==================================
• Never Seen Before Tricks
==================================
Other excel vba training Video :
==================================
School Manager - Student Admission, Student Receipt, School Software
• School Manager Pt 1 | ...
Small Business Applications - sale/purchase/inventory
• Small Business Applica...
Employee Manager
• Employee Manager
School manager in excel
• School Manager
DatePicker in excel
• DatePicker
Advance Data Entry Software in excel
• Advance Data Entry App...
PoS in Excel with Image Control
• PoS with Image Control
PoS in Excel
• PoS ( Point of Sale) i...
===================================
Our Social Media Contact :
===================================
Facebook : profile.php?...
Instagram : / vbafun.ajay
Facebook Group : / 264521978273573
Facebook Page : / excelapplicationvbafun
Twitter : / ajaypreetam
====================================
Disclaimer :
=====================================
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research, Fair use is a permitted by copyright statute that might otherwise be infringing, Non-profit, educational or personal use tips the balance in favor of fair use
=====================================
#ExcelApplication #Whatsapp #dataentry #excelvba
@computergyan8334 Жыл бұрын
🙏👍👏You are really "Magican of excel VBA" Very helpful method and code Thank you so much
@vbAFun Жыл бұрын
Welcome and thank you for your like and share it help us
@shahqasim8513 Жыл бұрын
GREAT TEACHER AND GENIOUS MAN YOU ARE ! THANKS SIR 🌺🌺
@vbAFun Жыл бұрын
Thank you and i appreciate keep watching
@SyedMuzammilMahasanShahi Жыл бұрын
That is amazing. Thanks for the share.
@vbAFun Жыл бұрын
I appreciate, please share this video to help us
@mohanbalodia3060 Жыл бұрын
Very Good Teacher
@cosmosos11 2 ай бұрын
Very very useful and interesting video sir
@nEcTArsTha Жыл бұрын
you are genius sir
@elija_ed_vann Жыл бұрын
Tons of likes and thanks..Sir🥰😇
@vbAFun Жыл бұрын
I appreciate thank you for your like and share it help us
@annabathulavekatagovindara8883 Жыл бұрын
Good concept nice trick Thank you
@vbAFun Жыл бұрын
Thank you for your support
@veeranjikumar6097 Жыл бұрын
Good concept. And nice trick
@vbAFun Жыл бұрын
Thank you ❤️
@user-cw2hr1gb4l 9 ай бұрын
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
@aravindreddy9737 Жыл бұрын
Thanks!
@vbAFun Жыл бұрын
Welcome and thank you ❤️
@intakhabkhan9649 Жыл бұрын
Nice video sir.
@vbAFun Жыл бұрын
Thank you
@trickysportsbesttricks7383 3 ай бұрын
very nice
@caremarkdrzafran Жыл бұрын
Masha Allah
@vbAFun Жыл бұрын
Thank you
@pdqmr10 Жыл бұрын
Sir, U R really appreciated person. Plz sir, create project for sending payslip via telegram app/software?
@vbAFun Жыл бұрын
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?
@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
@kunalbose1075 3 ай бұрын
❤
@jajraj 7 ай бұрын
Thanks, Sir Sir mera ak question hay kya may app say bat kar saka hu
@bhavneshparikh8283 Жыл бұрын
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
@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
@hariom3672 Жыл бұрын
Sir Not Run this Code. Plese Help
@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
@kamraniqbal6058 Жыл бұрын
Great work how can send slip in difference numbers
@vbAFun Жыл бұрын
You can use same method for that
@pintuchoyan9526 Жыл бұрын
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.
@vbAFun Жыл бұрын
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
@PinkalPrajapati-ue1wd 5 ай бұрын
Please, Help me I want run this program but image do not able to copy & paste in WhatsApp by code.
@amiyplacement7150 Жыл бұрын
Ajay Sir, Is it possible to Salary Slip as a pdf to every memeber over the WhatsApp..?
@vbAFun Жыл бұрын
Yes it is possible I have already uploaded video to send file as attachment on whatsapp
@aqeelahmad1764 Жыл бұрын
Amazing
@vbAFun Жыл бұрын
Thank you
@aqeelahmad1764 Жыл бұрын
@@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 ?
@vbAFun Жыл бұрын
I think maine uske liye method bata rakha hai how to generate QR. Ode bale me same method aap use kar sakte ho
@aqeelahmad1764 Жыл бұрын
@@vbAFun thkns I'll be try
@aqeelahmad1764 Жыл бұрын
I have tried now but fail Variable not found ata hai
@rajeshbhosle5132 Жыл бұрын
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
@tech11.786 9 күн бұрын
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
@devbaraiya8984 Жыл бұрын
Respected Sir me edge use karta hu usame next time allow dena padta hai please crome ka video banaye
@Akhileshvishwakarma564 3 ай бұрын
Microsoft Excel is waiting for another application to complete an OLE action errro aa rhaa h how to solve 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
@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 🌺🌺
@user-wx3bh2sq6m Жыл бұрын
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
@DiwakkarJnawali 7 ай бұрын
Sir 1 excel or google sheet se whatsapp message kaise bheje please make a simple video for the same
@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
@user-th3hf9lr2l Жыл бұрын
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
@vbAFun Жыл бұрын
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
@KundanFluteArt Жыл бұрын
Sir, whatsapp "group" me vba form se kese festivals msg kar sakte hai, kuch unique banaiye sir plz.
@vbAFun Жыл бұрын
Isko check karna hoga ki kaise kar sakte hai question unique hai mai try karta hun
@tech11.786 3 ай бұрын
Sir AAP jaisa knowledge ke liye kiya kare please replayme
@vbAFun 3 ай бұрын
Sir iske liye practice kare
@tech11.786 2 ай бұрын
Nice coment
@mathematicsclasseasyway9250 Жыл бұрын
Sir ek video book issue and return par banaye pleases sir
@hasmukhnirmal1263 Жыл бұрын
LIBRARY MANAGEMENT HO NA HAI
@HamzaAli-gg4fy 11 ай бұрын
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 11 ай бұрын
No it will send to all employees you need to run loop as i said in video
@syedshahzaibali4729 Жыл бұрын
Can we send whatsapp mess to group also ?
@bivaybabu5411 11 ай бұрын
Hello Sir, Could you provide the video link please if possible.
@vbAFun 11 ай бұрын
I made a another video ont that recently please visit channel and check
@user-fp8wq4xh5m 7 ай бұрын
hi sir your sheet is best working ..... please discription me iska link nahi h download ka please provide this sheet link ....thanks sir
@vbAFun 7 ай бұрын
File Updated
@user-fp8wq4xh5m 7 ай бұрын
@@vbAFun please share me link your sheet please
@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
@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
@llnowledge8144 11 ай бұрын
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 11 ай бұрын
Please wait I will upload with new trick for this
@AM-jd3rs Жыл бұрын
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.
@vbAFun Жыл бұрын
Restart the system and check again same problem hai to dubara se office install kare
@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 🌺🌺
@dilipsarda4u Жыл бұрын
Very nice👌 But text was not going in video
@vbAFun Жыл бұрын
Oh okay I have to check when I made that was working perfectly I think I have missed that
@nihal2750 8 ай бұрын
Sir Selenium chrome driver se kaise karein same bata doo
@vbAFun 8 ай бұрын
Okay wait will upload in future video
@imransayyed4461 5 ай бұрын
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
@vbAFun 5 ай бұрын
Can you connect me on instagram
@imransayyed4461 5 ай бұрын
@@vbAFun drop ur contact number directly also insta id
@anjankumarsahu9516 Жыл бұрын
Sir Google Chrome me WhatsApp Ho ga Kiya
@vbAFun Жыл бұрын
Haan kyu nahi but uske liye apko additional Libra use karna hoga
@subodhkushwaha11 11 ай бұрын
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 11 ай бұрын
Ek bar aap internet explorer ko default set kar do
@HamzaAli-gg4fy 11 ай бұрын
Sir, Can you please share the file link for further support, Thanks
@vbAFun 11 ай бұрын
Please check the latest video description on that
@HamzaAli-gg4fy 11 ай бұрын
Thanku Sir
@bivaybabu5411 11 ай бұрын
in windows 10 and office 365 it is not working. Please suggest
@vbAFun 11 ай бұрын
For this I made a recently video please watch that, I also used 365
@chhoenlida Жыл бұрын
Very good sir ..! Can you show us sent by telegram pls ?❤
@vbAFun Жыл бұрын
Do you want same thing on telegram, good idea will try
@chhoenlida Жыл бұрын
@@vbAFun yes sir I’m waiting ur video ..! Thank you reply
@vbAFun Жыл бұрын
Hi lida thank you for your comments, can I ask one thing that are you understand my explaining method
@chhoenlida Жыл бұрын
@@vbAFun yes sir For English is ok but ur languages I’m not .. I’m try to understand ur show step by step 🥰
@llnowledge8144 11 ай бұрын
Sir please send me your prepared Excel file which is shown in this video
@vbAFun 11 ай бұрын
Now a day this method is not working will upload anothe video with some different me hod for that
@llnowledge8144 11 ай бұрын
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.
@babasonk Жыл бұрын
Sir Please share the code for "Generate and email"
@vbAFun Жыл бұрын
Watch this video and check description kzfaq.info/get/bejne/gph3eaeGnc-nkpc.html
@babasonk Жыл бұрын
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.
@vbAFun Жыл бұрын
Use same method for your requirement
@anilkumarsharma5439 Жыл бұрын
Applying same codding is not working. Message is not appearing.
@vbAFun Жыл бұрын
Please check with runing code step by step
@llnowledge8144 11 ай бұрын
Sir please explain this video in english 😢
@ramakantamuduli4869 Жыл бұрын
sir WhatsApp par MSG bhejne ka koi limitation hai ya nahi ? yeh unlimited free hoga.
@vbAFun Жыл бұрын
Yes ye unlimited free hai jaise aapobile se karte hai ye kam usi tarah karta hai
@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
@aravindans6511 2 ай бұрын
Sir its asking everytime "allow to yes" what to do
@vbAFun 2 ай бұрын
You have to check your windows permission
@jaiprakashmahawar7236 10 ай бұрын
Sir how to send on group I want send in group
@vbAFun 10 ай бұрын
Idea is good will show in future video
@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
@anandsharma6102 Ай бұрын
Run error Lastrows
@amjadansaree Жыл бұрын
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
@vbAFun Жыл бұрын
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.
@afrinsir7479 Жыл бұрын
please provide code in description
@vbAFun Жыл бұрын
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 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
@llnowledge8144 11 ай бұрын
Sir please explain this video in English
@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
@pintuchoyan9526 Жыл бұрын
Please share file with code
@vbAFun Жыл бұрын
Okay will upload please try to make yourself by watching this video it will help you
@user-fp8wq4xh5m 7 ай бұрын
please..............? provide code vba
@vbAFun 7 ай бұрын
Please check description
@user-fp8wq4xh5m 7 ай бұрын
i need your sheet
@vbAFun 7 ай бұрын
you can download from the description
@Tecnical-Eng-PLC Жыл бұрын
Hi mster can you please send me the file
@vbAFun Жыл бұрын
This is very simple line of code u can write easily
@bhavneshparikh8283 Жыл бұрын
how to download sample file
@vbAFun Жыл бұрын
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
@bhavneshparikh8283 Жыл бұрын
@@vbAFun ok but sir in excel data require i put code it
@KaranSingh-mg2cp Жыл бұрын
Internet explorer has been depricated by Microsoft. It is not going to work longer. Show us how to use chrome browser for the same
@vbAFun Жыл бұрын
Idea is good will try to create a separate video
@pintuchoyan9526 Жыл бұрын
Also I need sir
@vbAFun Жыл бұрын
Thank yes will create a video on this
@firozhossen1485 Жыл бұрын
can you share the code.
@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
@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
@mathematicsclasseasyway9250 Жыл бұрын
kzfaq.info/get/bejne/eJyohrKXuLPWgn0.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 🙏🙏🙏🙏🙏🙏
@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
@muhammadnaumanaslam2962 8 ай бұрын
Earning ✔Correcct Spellings "Eearning"❌
@vbAFun 8 ай бұрын
Thank you 👍 for correct me
@mrgk3686 4 ай бұрын
Bro i have bill excel format.in the bill share what's app number send for customer number
@vbAFun 4 ай бұрын
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
@uznabee1 Жыл бұрын
@@vbAFun 🙏OK, Sir
@abuhammad8652 11 ай бұрын
Har member ko alag alag uski sellery sleep kaise send kore?
vbA Fun
Рет қаралды 12 М.
EXCEL DOERS
Рет қаралды 91 М.
Excel Mentor
Рет қаралды 684
vbA Fun
Рет қаралды 20 М.
MASTER EDUCATION( Computer science )
Рет қаралды 115 М.