+ Reply to Thread
Results 1 to 2 of 2

VBA macro to call and import control data from a network attached worksheet or ini?

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    17

    Question VBA macro to call and import control data from a network attached worksheet or ini?

    I have multiple worksheets my group uses that rely on data from a single control list that must be updated periodically, sometimes weekly. I want to have the worksheets dependent on that list automatically import the data each time the document is opened after it confirms the document is reachable. I know of a similar application using an .ini file, but I'm curious if I can easily do something similar with another Excel worksheet on a shared network store.

    The imported data will be used in various VLOOKUP functions in the worksheet, with multiple columns of data.

    Thanks in advance for a little direction here.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: VBA macro to call and import control data from a network attached worksheet or ini?

    There is a part of Excel called MS-Query. MS-Query can read data from a wide variety of data sources including another workbook. Once you define a worksheet as a data source, then you can write a query against it to limit columns and select rows. You can pass parameters to it and it can either prompt you or it can read parameters from a cell. So you can customize it for different users. One of the features it has is that it can update data on open and every X minutes.

    It's all part of the Data ribbon: no programming required.

+ 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. Pulling data from network location to import
    By amorshc in forum Excel General
    Replies: 12
    Last Post: 07-28-2015, 05:03 PM
  2. Need help with macro for filtering worksheet data based on combobox control
    By preetypj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2014, 07:28 AM
  3. HELP Import data from attached HTML file to excel
    By ExcelUser2707 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-25-2013, 09:24 AM
  4. [SOLVED] Match staff name and date then import data from matched row (Example attached)
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-26-2012, 10:33 AM
  5. Userform Call Macro on Control Change
    By fire_water in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2009, 12:42 PM
  6. call a sub from an xls file on the network
    By DKY in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-02-2008, 07:19 PM
  7. Data Import Macro - can't copy the value to the worksheet of GetData.
    By susuyesyes in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-06-2008, 04:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1