Ping an IP (using the IP from a cell)

**Chris424** · 06-18-2009, 05:35 AM

Does anyone know how to Ping an IP (using the IP from a cell)

so if A1 is 10.65.1.1
Ping 10.65.1.1 and give a msgbox saying "sucessful" or "not successful"

I can do it using VBScript but cant work out how to do it in VBA.

Please Login or Register  to view this content.

I have searched but cant find anything that is close to what I need.

Any help would be fab

**romperstomper** · 06-18-2009, 06:09 AM

The literal equivalent is not that different:

Please Login or Register  to view this content.

**Chris424** · 06-18-2009, 06:20 AM

That is perfect! You are brilliant!

Thank you soooooo much

**romperstomper** · 06-18-2009, 06:48 AM

Hey Donkey (

) - how's tricks? Any plans for a foray into London anytime soon?

**DonkeyOte** · 06-18-2009, 07:18 AM

Hey! No immediate plans to leave deepest darkest Suffolk but you never know

Trust the family is doing well!

(hijack over before I have to infract myself!)

**Chris424** · 06-18-2009, 09:43 AM

I know I am being picky now

Is there any way to stop the black box popping up? Or have it minimized so it doesnt show?

I have attached a screenshot of what I mean

Thanks again for all your help

**romperstomper** · 06-18-2009, 10:08 AM

Not with that method, I don't think. You could use API functions instead - simplistic version below. The Ping function returns True if successful:

Please Login or Register  to view this content.

Ping an IP (using the IP from a cell)

LinkBack

Thread Tools

Rate This Thread

Display

Ping an IP (using the IP from a cell)

Re: Ping an IP (using the IP from a cell)

Re: Ping an IP (using the IP from a cell)

Re: Ping an IP (using the IP from a cell)

Re: Ping an IP (using the IP from a cell)

Re: Ping an IP (using the IP from a cell)

Re: Ping an IP (using the IP from a cell)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions