+ Reply to Thread
Results 1 to 3 of 3

VBA help gathering data from specified device

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    70

    VBA help gathering data from specified device

    I'm new to VBA, but understand a few basics on it. I have an excel sheet that would contain a list of IP addresses and I essentially want to set-up a command button that when hit, it will go out to each of the IP's listed, enter the password, and return a specific piece of data (a power load for a plant controller) and put that in another cell on the sheet.

    I've seen these things done before, but have nothing to referece on where to begin setting something like this up. Any pointers or help steering me in the right direction would be greatly appreciated. :)

  2. #2
    Registered User
    Join Date
    08-26-2013
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: VBA help gathering data from specified device

    Anyone? Anyone? Bueller? Bueller?

  3. #3
    Forum Contributor
    Join Date
    12-27-2012
    Location
    cebu, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    210

    Re: VBA help gathering data from specified device

    you may need further knowledge on other programming languages for that...

    or a closer step you can use from visual basic is the "Send keys statement" to navigate through applications that are not created by VBA...

    far far beyond...
    don't worry, there's a lot of people that are far more confused than you
    but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data acqusition from usb device to excel
    By alansimpson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2013, 12:58 PM
  2. Gathering particular data
    By kishoremcp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2012, 07:26 PM
  3. Data Gathering
    By AdamMiller in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-20-2009, 04:19 PM
  4. How do linked worksheets exist with data on an external device
    By tazzer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-05-2006, 04:45 AM
  5. gathering data
    By xak_tay in forum Excel General
    Replies: 0
    Last Post: 09-30-2005, 02:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1