WhatsApp Not stayed in same TAB

[smtazulislam]

Hi, I using the google chrome browser. I would like to do if I click to whatsApp button then It is open chrome browser directly where I already opened a TAB.
But I facing every click open new tab in chrome browser. Also If I using the Gchrome as Object then get error.
How do I fix it.

Noted : Daily 40-50 whatsApp replying every single days. Same message just replace EmployeeID and NID Numbers. every click it was opened new tab with attached pciture.

Any help will be appreciate.

Option Compare Database
Option Explicit

Private Sub cmdWhatsApp_Click()
'Format : https://wa.me/whatsappphonenumber?text=urlencodedtext where whatsappphonenumber
'Dim Gchrome As Object
Dim strInput As String
Dim strMyNumbers As String

'Set Gchrome = CreateObject("chrome.Application")
strMyNumbers = "0096*******21"
strInput = "https://web.whatsapp.com/strMyNumbers"
Application.FollowHyperlink strInput, , True

'Set Gchrome = Nothing
End Sub

 

[Uncle Gizmo]

I noticed that you have yet to receive a reply. Hence I am bumping up your post so that it gets another look. I would say the information in your post is a little sparse, it might pay to add a bit more information.

 

[Isaac]

Oh my.
If only it were true that we could just "create" all programs on our computer by just typing "chrome.applicaton" !!

I'm afraid you are confusing this with Office interoperability. There is no createobject("chrome.applicaton") exists.

Something like this might work:

Dim chromePath As String
chromePath = """C:\Program Files\Google\Chrome\Application\chrome.exe"""
Shell (chromePath & " -url http:google.ca")

 

[smtazulislam]

Oh my.
If only it were true that we could just "create" all programs on our computer by just typing "chrome.applicaton" !!

I'm afraid you are confusing this with Office interoperability. There is no createobject("chrome.applicaton") exists.

Something like this might work:

Dim chromePath As String
chromePath = """C:\Program Files\Google\Chrome\Application\chrome.exe"""
Shell (chromePath & " -url http:google.ca")

Hello sir,
my code is worked. it was opening every click with new TAB in chrome browser.
I want to opened in previous TAB.
This is my question. Thank you.

 

[CJ_London]

have you looked at Chrome settings?

 

[smtazulislam]

Thank you.
No work. it was open a new TAB in the chrome as before.

 

[CJ_London]

What code are you using to open chrome, perhaps try a different way as suggested by isaac

 

[smtazulislam]

What code are you using to open chrome, perhaps try a different way as suggested by isaac

I dont try it. because Post : 1 code is worked.
I tried to your suggested to change the SETTING in chrome . But not working. it was opening with a new TAB.

 

[CJ_London]

clearly your code ignores or bypasses the chrome setting - which tells you something about your code? i.e. it doesn't work for what you actually want

 

[smtazulislam]

clearly your code ignores or bypasses the chrome setting - which tells you something about your code? i.e. it doesn't work for what you actually want

Yes sir,
can possible without open WhatsApp application in web. there have any system to sending message multiple WhatsApp numbers via ACCESS.

Everyday we have instruction to worker supervisor work schedule what to do next 2/3 hours. It was change the "EmployeeID" and "Department Name". Other almost messages is same.

Multiple Numbers:
if I create a form in a list box and selected multiple employee with add message text box (instruction details).

Or,
have any solution in other ways ?

 

[CJ_London]

I don’t have a solution - usual way is to use sms instead

 

[KitaYama]

Or,
have any solution in other ways ?

We've been trying to do what you need for years, and failed. Chrome opens the links in a new tab by default. There are addins that control this behavior, but they all work within the browser. It means they can do their job if a link in a tab is clicked. They can do nothing against external links.
We couldn't find any way to make Chrome to reuse a tab.

We ended up not using Whatsapp web.

We installed WhatsApp for windows from here.
Then we create a bat file in our desktop that contains only one line:
start whatsapp:
When we want to open whatsapp via a form in Access, we run the bat file:
Shell "C:\Users\KitaYama\Desktop\Whatsapp.bat"

This is the closest way we could do what we need.
Still I'm interested if anyone else has a better way.

 

[KitaYama]

One more point.
By installing SeleniumBasic and re-use chrome driver, you can do a lot more in VBA.
This is a tutorial. There are more. Just search for SeleniumBasic.

 

[KitaYama]

And one last advice.
We had a lot of problems with WhatsApp.

We had to stop using WhatsApp and move to Microsoft Kaizala.
It's far better than WhatsApp with a lot more features for organization. WhatsApp is more for public.

Just give it a try. It's free and can be used by anyone.

 

[CJ_London]

you might be able to use the whatapp api

Cloud API - Documentation - Meta for Developers

developers.facebook.com