+ Reply to Thread
Results 1 to 15 of 15

To automize when source folder varies, receiver file name is fixed, file location changes

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: To automize when source folder varies, receiver file name is fixed, file location chan

    Hi Orhtex

    Strange ... I replied to this a couple of days ago, but my reply is not here?

    If you did get the last solution, then here is the new improved version. Copy the Master file to a directory of your choosing and it will bring in all Excel file data.

    Let me know how you get on.

    Regards
    Alastair
    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. Copy, edit and save workbook to same location as source data file, not macro file.
    By Jasonhouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2014, 09:01 AM
  2. [SOLVED] Display the link of the file from fixed folder when the file is selected from drop down
    By vignesh805 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2013, 06:38 AM
  3. How to add worksheet before another known worksheet that varies in location in file
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-05-2012, 08:57 AM
  4. Browse for File with Suggested Folder Location?
    By Khirsah17 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2010, 09:10 AM
  5. Save as macro with location prompt but fixed file name ?
    By Simon-ch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-31-2008, 07:52 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