+ Reply to Thread
Results 1 to 6 of 6

Force Relative File Links/Pull In Lots of Files?

  1. #1
    Registered User
    Join Date
    10-09-2014
    Location
    Carmel, IN
    MS-Off Ver
    2011
    Posts
    6

    Force Relative File Links/Pull In Lots of Files?

    I'm a recent addition to the forum and am having a tough time trying to figure out how to deal with a grading spreadsheet that will pull in a few hundred serial numbered files with a couple hundred references in each.

    Is there a way to pull files in that are in the same directory without the likelihood that Excel will add a path against my will? I will be sharing the spreadsheet with others who will put the serial numbered files in the directory, so I can't have the risk the user will be stranded. Does anyone have ideas? Thanks so much!!

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Force Relative File Links/Pull In Lots of Files?

    I would suggest you use a macro to open and import all the individual files into a single master file for data further data manipulation and reporting. Trying to link to that many files dynamically can be done, but does it need to be?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Force Relative File Links/Pull In Lots of Files?

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste anyone's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please include links to any and all cross-posts in any other forums (not just this site).


    CROSSPOST: http://www.mrexcel.com/forum/excel-q...ots-files.html


    When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.

    (link above in the menu bar)

  4. #4
    Registered User
    Join Date
    10-09-2014
    Location
    Carmel, IN
    MS-Off Ver
    2011
    Posts
    6

    Re: Force Relative File Links/Pull In Lots of Files?

    My apologies for the cross-link without reference. It won't happen again.

    Thank you for the suggestion for using a macro to do this. I have searched around for a technique to pull the data in for a number of files without much success. I've used macros before, but none involving files. Could you point me toward a technique that does something similar? If so, that would be fantastic. Thanks!!

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Force Relative File Links/Pull In Lots of Files?

    'WORKBOOKS TO 1 SHEET STACKED
    Here's a macro for collecting data from all files in a specific folder.The parts of the code that need to be edited are colored to draw your attention.
    Last edited by JBeaucaire; 12-26-2019 at 04:48 PM.

  6. #6
    Registered User
    Join Date
    10-09-2014
    Location
    Carmel, IN
    MS-Off Ver
    2011
    Posts
    6

    Re: Force Relative File Links/Pull In Lots of Files?

    This was fabulous. Thank you very much for the help! I have one thing I can't figure out (short of figuring how to make this work on Macs): copying and pasting special. I've tried the VBA pasteSpecial I know and I can't seem to make it work.

    Jerry uses a command like this what is in bold:
    Please Login or Register  to view this content.
    Does anyone know how to make the paste that occurs pasted as values? Thanks!!!!!!!!

+ 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. Replies: 2
    Last Post: 10-13-2014, 01:02 PM
  2. Replies: 1
    Last Post: 01-06-2012, 12:31 PM
  3. Transfering files from lots of files to one single Exel master file.
    By yjacob in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-01-2009, 11:37 AM
  4. [SOLVED] Importing lots of CSV files into an XLS file as different workshee
    By rmellison in forum Excel General
    Replies: 4
    Last Post: 01-05-2006, 07:30 AM
  5. [SOLVED] Ghost Links which force Excel to update on File Open
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2005, 09: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