Make a new macro (Macro B) to automatically run old mcro (Macro A) in MS Excel
Budget: ₹600 – ₹1,500 INR
Macro A (attached) - is ussed to run my whatsapp bot automatically which I sourced from this placehttps://pythonandvba.com/blog/how-to-send-bulk-whatsapp-messages-from-excel-using-vba-free-easy/
Make a new Macro B (without editing anything in Macro A)
1. Put content from another Sheet 1 Tab into the Bot Tab (overwrite)
2. Click on "Run whatsapp Bot" in the Bot Tab
3. then after the chrome browser opens the whatsappweb wait for some 1..to 1.5 minutes while the pop up appears in the back side in excel. Pls note that the "OK" button should get pressed automatically by Macro ONLY AFTER the entire webwhatsapp has started in Chrome browser and synced
4. Then click "OK" on that pop up so that the chrome browser can start running the whatsapp messages
Also before the data is overwritten in BoT Tab, make a new sheet Sheet 2 to copy contents in BoT tab in Sheet 2
Make a new Macro B (without editing anything in Macro A)
1. Put content from another Sheet 1 Tab into the Bot Tab (overwrite)
2. Click on "Run whatsapp Bot" in the Bot Tab
3. then after the chrome browser opens the whatsappweb wait for some 1..to 1.5 minutes while the pop up appears in the back side in excel. Pls note that the "OK" button should get pressed automatically by Macro ONLY AFTER the entire webwhatsapp has started in Chrome browser and synced
4. Then click "OK" on that pop up so that the chrome browser can start running the whatsapp messages
Also before the data is overwritten in BoT Tab, make a new sheet Sheet 2 to copy contents in BoT tab in Sheet 2