+ Reply to Thread
Results 1 to 1 of 1

Trying to resolve two issues, one with queries the other modifying query source

  1. #1
    Registered User
    Join Date
    01-08-2017
    Location
    Salt Lake City, Ut.
    MS-Off Ver
    2010
    Posts
    92

    Question Trying to resolve two issues, one with queries the other modifying query source

    I have an excel workbook where I have sheets for months Jan through Dec. As part of a backup routine I export data from these sheets to CSV files.

    When I want to import these sheets, initially I created this within my own user profile, so the query path reflects my username in the source path. I would like to do two things, first be able to alter the query source so that it will work for any user that is logged in at the time, thus making the file distributable to other users. I have extracted the queries to a worksheet that I will attach to this post. The second thing would be able to activate the queries from the excel sheet where they are extracted to, but I have not found a way to do that either?
    Attached Files Attached Files

+ 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. [SOLVED] Macro to resolve a logic query
    By jamewoong in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-18-2017, 05:56 AM
  2. Replies: 5
    Last Post: 02-20-2016, 01:26 AM
  3. Replies: 0
    Last Post: 06-18-2014, 11:54 AM
  4. Replies: 0
    Last Post: 04-22-2014, 07:09 PM
  5. [SOLVED] Sorting issues to be resolve...
    By vlady in forum The Water Cooler
    Replies: 5
    Last Post: 08-31-2012, 03:38 AM
  6. Issues to Resolve (as of Feb 3, 2012)
    By NBVC in forum The Water Cooler
    Replies: 28
    Last Post: 02-09-2012, 06:54 AM
  7. Replies: 0
    Last Post: 08-16-2006, 11:25 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