Скачать или смотреть Excel To WhatsApp - Code Explanation

We want to send multiple WhatsApp messages based on the data available in our Excel file.

Procedure to do the task:
1. Install Microsoft .NET Framework 3.5:
https://www.microsoft.com/en-us/downl...
2. Install SeleniumBasic:
https://github.com/florentbr/Selenium...
While installing, just take note of the folder where SeleniumBasic is installed.
3. Enable Selenium in VBA References:
Open Excel and press Alt+F11. Go to Tools, Select References. Then Enable "Selenium Type Library"
4. Identify the version of your Chrome: Type this in the address bar of the Chrome browser.
chrome://settings/help
5. Download the ChromeDriver based on the chrome version found in Step 4:
For versions older than 115, you can get from:
https://developer.chrome.com/docs/chr...
For later versions:
https://googlechromelabs.github.io/ch...
6. Extract the ZIP file and copy the chromedriver.exe file into the SeleniumBasic folder. Please note that this will override the existing chromedriver.exe file there.
7. Open the provided Excel file. Update with your data. Then click the button (Send WhatsApp Messages) provided.

The Excel file is shared via:
https://mibuhari.github.io/ExcelToWha...

The Macro code is available at:
https://mibuhari.github.io/ExcelToWha...

[00:00:00] – Intro: Send WhatsApp from Excel with VBA
[00:00:44] – Log in to WhatsApp Web (QR scan & confirm)
[00:01:23] – Open Macro Editor; Selenium WebDriver overview
[00:02:04] – Count rows & map sheet columns (A–I)
[00:04:01] – Compose message: bold text & variable inserts
[00:04:51] – Locate chat box; enter phone; press Enter safely
[00:05:41] – Create multi-line messages with Shift+Enter
[00:07:47] – Install prerequisites: .NET 3.5 & SeleniumBasic
[00:08:32] – Match ChromeDriver to Chrome; copy into folder
[00:09:20] – Enable “Selenium Type Library” in VBA References