+ Reply to Thread
Results 1 to 2 of 2

Linking Two Workbooks in the Same Folder and Excluding the Folder Location

  1. #1
    Registered User
    Join Date
    12-28-2017
    Location
    Oklahoma City, OK
    MS-Off Ver
    2010
    Posts
    1

    Linking Two Workbooks in the Same Folder and Excluding the Folder Location

    This template is being used to break down a file into five unique files that are frequently uploaded. While this template will be saved in multiple locations, the 'source' file will always be stored in the same folder as the template and will always have the same name.

    I have two workbooks in the same folder. When I link cells between the two workbooks, I get:

    ='[File Name]Tab Name -1'!$P$1302

    Everything works well at that point. When I close the 'source' file, all of my linked formulas change to:

    ='File Location\[File Name.xlsx]Tab Name -1'!$P$1302

    This means that all of the template's cells are linked to the 'source' file in a very specific location. My goal is to save a 'Template_Folder' in multiple places because each template will be fed a unique 'source' file.

    Am I missing an easier way? I've tried searching a plethora of key words, but am coming up empty handed on this deal.

    Thanks and have a good day!
    Michael
    Last edited by 96Mustang460cid; 12-28-2017 at 06:30 PM.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Linking Two Workbooks in the Same Folder and Excluding the Folder Location

    you can use Find and replace and change File Location.
    one can automate this with macro recording

+ 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] VBA Code to save to a folder within a folder within a folder all based on cell values.
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-24-2016, 04:24 PM
  2. [SOLVED] Looking for Macro to pull folder name and folder size of a specific location.
    By TheDirtyDrunk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2016, 09:19 AM
  3. Open Folder (Prompt User for final folder name in location path)
    By synergeticink in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2014, 03:33 PM
  4. create new folder at one location and copy photos in that folder from other location
    By meer_ali in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2014, 05:20 AM
  5. create a compressed folder or zipped folder then copy workbooks to it.
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2012, 03:56 PM
  6. linking two workbooks in different folder locations
    By Andyd74 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2006, 10:19 AM
  7. Replies: 6
    Last Post: 08-11-2006, 03:41 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