Results 1 to 15 of 15

Need assistance with quering remote workbook

Threaded View

  1. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,641

    Re: Need assistance with quering remote workbook

    Hi again,

    Thanks for your last post.

    Quick question - does the Supervisor workbook contain one worksheet for each agent?

    More questions - does each Agent worksheet correspond to a single month? If so, does that mean that there is a theoretical maximum of 31 worksheets in an Agent workbook and 31 rows for each agent in the Supervisor workbook? Are agent worksheets always named sequentially starting from "1"?

    The answers to these questions will help me to decide how best to check for worksheets missing from the Agent workbooks.

    Regards,

    Greg M
    Last edited by Greg M; 01-14-2014 at 06:02 AM. Reason: More questions added

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Quering information from sql database
    By Brice112 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2012, 06:53 PM
  2. using numbers from websites into excel (web Quering)
    By kaiouji in forum Excel General
    Replies: 3
    Last Post: 01-02-2011, 01:47 AM
  3. summarise data in remote workbook
    By BRISBANEBOB in forum Excel General
    Replies: 1
    Last Post: 02-18-2010, 06:20 AM
  4. Macro to copy data to remote workbook
    By RJPotts in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2008, 11:46 PM
  5. Cannot insert remote .jpgs from remote site
    By Laura Keating in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2007, 11:39 AM

Tags for this Thread

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