+ Reply to Thread
Results 1 to 2 of 2

Open & close the Active excel file by vba macro (Macro Modification)

  1. #1
    Registered User
    Join Date
    05-10-2020
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    92

    Open & close the Active excel file by vba macro (Macro Modification)

    Hello Guys,

    Please Login or Register  to view this content.

    This macro works perfect but little modification is there
    it closes the step3.xlsb & opens the step4.xlsb located at C:\Users\WolfieeeStyle\Desktop
    But there is a chance that may be step4.xlsb file will be present or it will not be present So if step4.xlsb is present then open that step4.xlsb & if not then open step1.xlsb which is also located at C:\Users\WolfieeeStyle\Desktop
    In short If step4.xlsb is not present then step1.xlsb will be present & if step1.xlsb is not present then step4.xlsb will be present



    Thnx

  2. #2
    Valued Forum Contributor
    Join Date
    08-03-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, Office 365
    Posts
    467

    Re: Open & close the Active excel file by vba macro (Macro Modification)

    Hi quirkybox

    Try this..
    Please Login or Register  to view this content.
    zeddy

+ 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 open Excel file, run other macros save, and close file & repeat.
    By Ronnet2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2015, 09:47 AM
  2. macro to close excel file and open another excel file
    By freak11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2014, 04:49 PM
  3. Replies: 0
    Last Post: 10-02-2013, 01:47 AM
  4. [SOLVED] Macro - Open one file then close another
    By aetedford in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2013, 10:02 AM
  5. [SOLVED] Macro to open every file in a folder, run a certain macro and close each file.
    By masben in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2013, 05:45 AM
  6. Need Help with Excel Macro - Open - Close File
    By Lpitt56 in forum Excel General
    Replies: 6
    Last Post: 01-26-2012, 03:31 PM
  7. [SOLVED] Macro to open and close an Excel file
    By Magnivy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2006, 11:35 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