VBA MAC TESTING INTERNET CONNECTION

Question

Hi,

In Excel MAC 2016 (Office 365) with VBA i want to know how to testing internet connexion.

There are methods under windows using wininet.dll but of course not compatible MAC.

Can you help me ?

Regards

Hugues

Answer 1

Hi Phillip,

Thank try to help me

Regards

Hugues

Answer 2

Hi Hugues,

There are a couple different approaches you could take. It depends on your skill level and what programming languages you know.

The connection is controlled by Mac OS. You can program both Mac OS and Excel using Objective-C. See this link for information about the connection in Objective-C

connection

A less elegant way to handle this if you don't want to use Objective-C is to try the query and if it fails, handle it in your code.

Answer 3

You have to wait for a VBA Expert to come by. Sorry I could not help. 

__________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Volunteer Moderator.

Answer 4

Hi Philip,

Thank's for your answer

But i need to use a test in Excel with VBA (To Stop a Query if there is no internet connexion)

Regards

Hugues

Answer 5

I have no idea how to to do VBA. If you want to test whether the Internet (WiFi) is working and how well I have directions below.

If using Wi-FI  click on the wifi symbol in the main Finder menu  click on the WIFi symbols

Option-click on the symbol, a menu will pop up

__________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Volunteer Moderator.