+ Reply to Thread
Results 1 to 6 of 6

Open file code switch off when name changed

  1. #1
    Registered User
    Join Date
    11-25-2012
    Location
    Swansea, Wales
    MS-Off Ver
    Excel 2003
    Posts
    55

    Open file code switch off when name changed

    I have a code that ON OPENING of the workbook it automatically gathers key data from other workbooks.

    The workbook does various things........ but at the end it collates data and saves under a new file name.

    The problem is the original code is still active, is there a way of switching it off after the name change???

    The original file name is Actuals Part 2 and then the final name could be September Actuals...

    Is it possible to say if file name = Actuals Part 2 then rum but if not then don't run.

    ????? Confused

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Open file code switch off when name changed

    I suppose this might work

    Please Login or Register  to view this content.
    Untested
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    11-25-2012
    Location
    Swansea, Wales
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Open file code switch off when name changed

    Thanks

    On my test file it works...

    Will try on the master file tomorrow.... should work

    Thank you for you help

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Open file code switch off when name changed

    glad I could help....let me know...or set the thread to Solved if it worked...

  5. #5
    Registered User
    Join Date
    11-25-2012
    Location
    Swansea, Wales
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Open file code switch off when name changed

    Yes worked well

    Thanks

  6. #6
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Open file code switch off when name changed

    excellent....

+ 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. Open xls file via URL link, and automatically filter on a switch or value in the link?
    By linksavage in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 02:27 PM
  2. [SOLVED] Open two workbooks into one excel program, then macro code for button to switch between
    By oldboots in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-14-2013, 09:30 AM
  3. VBA for excel 2003. Open file dialog box, open 2007 file xlsx, continue with code
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2011, 12:12 AM
  4. Replies: 0
    Last Post: 07-28-2005, 08:05 PM
  5. Open File or Switch Between Windows if File is Open
    By Ricky Pang in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-08-2005, 01: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