+ Reply to Thread
Results 1 to 7 of 7

Using "GetObject" and "winmgmts" to ping devices.

  1. 01-12-2016, 09:57 AM #1
    Rhudi is offline
    Forum Contributor Rhudi's Avatar
    Join Date
    03-08-2013
    Location
    South Carolina, US
    MS-Off Ver
    Professional Plus 2016 aka Office 365
    Posts
    201

    Using "GetObject" and "winmgmts" to ping devices.

    I found the following bit of code online yesterday. This is awesome in it's speed. I have been using an entirely different method to ping devices from within Excel. This code is much faster.

    However, I do have a question about it. I don't understand its syntax. How would I add the parameter to shorten the time out? Currently, it is about 2 seconds. In my case, I'd be happy shortening that to 1/2 second ( 500ms ).
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-12-2016, 10:16 AM #2
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Using "GetObject" and "winmgmts" to ping devices.

    Your time out is in another piece of code.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files
    Reply With QuoteRegister To Reply
  3. 01-13-2016, 01:05 AM #3
    Rhudi is offline
    Forum Contributor Rhudi's Avatar
    Join Date
    03-08-2013
    Location
    South Carolina, US
    MS-Off Ver
    Professional Plus 2016 aka Office 365
    Posts
    201

    Re: Using "GetObject" and "winmgmts" to ping devices.

    Ok... So you made me look...

    And, this I found:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 01-13-2016, 02:44 AM #4
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Using "GetObject" and "winmgmts" to ping devices.

    What is this variables value.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 01-13-2016, 01:37 PM #5
    Rhudi is offline
    Forum Contributor Rhudi's Avatar
    Join Date
    03-08-2013
    Location
    South Carolina, US
    MS-Off Ver
    Professional Plus 2016 aka Office 365
    Posts
    201

    Re: Using "GetObject" and "winmgmts" to ping devices.

    Ok, let me post the entire function... :P
    Please Login or Register  to view this content.

    Here is how this is called (just to play with it):
    Please Login or Register  to view this content.
    Last edited by Rhudi; 01-13-2016 at 01:48 PM. Reason: Add detail...
    Reply With QuoteRegister To Reply
  6. 01-14-2016, 07:32 PM #6
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Using "GetObject" and "winmgmts" to ping devices.

    Change this line.

    Please Login or Register  to view this content.
    And BTW, if you had post the full code in the first place, it would have been solved a lot quicker.
    Last edited by JapanDave; 01-14-2016 at 07:39 PM.
    Reply With QuoteRegister To Reply
  7. 01-14-2016, 07:43 PM #7
    Rhudi is offline
    Forum Contributor Rhudi's Avatar
    Join Date
    03-08-2013
    Location
    South Carolina, US
    MS-Off Ver
    Professional Plus 2016 aka Office 365
    Posts
    201

    Re: Using "GetObject" and "winmgmts" to ping devices.

    I'm tweaking the timout value to speed things up. I'd lowered it to 350.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"
    By savekels in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  3. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. Formula returning result of "True" or "False" instead of "1" or "0"
    By AllenMead in forum Excel General
    Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  6. HELP on "left","right","find","len","substitute" functions
    By serene83 in forum Excel General
    Replies: 5
    Last Post: 06-26-2006, 09:23 PM
  7. Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
    By BCB in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-13-2006, 05:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1