+ Reply to Thread
Results 1 to 3 of 3

VBA one script, save as, close and open again

  1. #1
    Registered User
    Join Date
    10-26-2016
    Location
    Czech republic
    MS-Off Ver
    MS office 2016
    Posts
    39

    VBA one script, save as, close and open again

    Hello,

    Please, is posible to perform this action? (save as, close and again open with one VBA script)

    Description:

    1) You have file: "test1.xlsm".

    2) You will do some changes and save them.

    3) You will save file as "test2.xlsx"

    4) after it you close ActiveWorkbook.Close SaveChanges:=False

    5) I need open "test1.xlsm" again. And here I have problem, the workbook is not opened
    And aplication excel is without workbook.

    Thank you in advance for advice.

    Regards.

    Martin

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: VBA one script, save as, close and open again

    I would instead just save as TEST2 then open TEST1 then close TEST2.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    10-26-2016
    Location
    Czech republic
    MS-Off Ver
    MS office 2016
    Posts
    39

    Re: VBA one script, save as, close and open again

    Thank you for answer,

    I am sorry, you are right but I cannot do it because "test2" will saved without vba support as .xlsx (problem is in .xlsx macro disabled)

    But I really think that this is good way I am trying experiment whit this now...

    Is possible that you are right and I am confused.

    Can you try to create test file? For path c:\test

    Martin

+ 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, Run, Save and Close
    By fred3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2014, 01:13 PM
  2. Save As but keep active wb open but the Save As .close
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2014, 01:45 PM
  3. Replies: 2
    Last Post: 04-10-2014, 07:06 AM
  4. [SOLVED] Close open workboos with script
    By kjsconv in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-22-2013, 09:52 PM
  5. [SOLVED] VBA to open, edit, save and close
    By AZZ70 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-24-2012, 02:01 PM
  6. Save and Close Open File
    By cmcgath in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-17-2010, 10:35 AM
  7. Open WB / Run Macro / Save changes /Close WB
    By nachousa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2010, 01:08 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