+ Reply to Thread
Results 1 to 5 of 5

Convert File from xlsm to xlsx

  1. #1
    Registered User
    Join Date
    11-09-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    59

    Convert File from xlsm to xlsx

    I have a code that saves a new file. (with a versioning piece as well) It works, but I would like to change it so either the new file, or the new version of the file, is .xlsx, and not .xlsm.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Convert File from xlsm to xlsx

    Given existing code, modify SaveExt to be xlsx

    Note: with alerts enabled you will get a prompt when saving as .xlsx given this type does not support macros, assumed to be a deliberate action on your part.

  3. #3
    Registered User
    Join Date
    11-09-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    59

    Re: Convert File from xlsm to xlsx

    Thanks for the help. I have changed SaveExt to
    Please Login or Register  to view this content.
    Am I doing that correctly? the macro is stopping at
    Please Login or Register  to view this content.
    So, I assume I did something wrong.

    As for alerts, no, I do not want that prompt to display. I assume
    Please Login or Register  to view this content.
    will handle that?

  4. #4
    Registered User
    Join Date
    11-09-2018
    Location
    USA
    MS-Off Ver
    365
    Posts
    59

    Re: Convert File from xlsm to xlsx

    Hi,
    I figured out what the issue was. I needed to add the file format to the line where the macro was stopping
    Please Login or Register  to view this content.
    Thanks for your help.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Convert File from xlsm to xlsx

    You cannot save a macro in .xlsx format, it gets removed.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Import data from .XLS, xlsx file into .xlsm file and do vlookup
    By pacificepoc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2018, 01:32 AM
  2. Convert between Excel file format macro option formats (.XLS, .XLSX, .XLSM)
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2018, 03:53 PM
  3. Replies: 1
    Last Post: 12-01-2016, 10:57 AM
  4. [SOLVED] VBA, convert tool from XLSM to XLSX; I need ignore "locked file"
    By martin81 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-29-2016, 03:54 AM
  5. Help with code to convert xls to xlsx and continue with xlsx file
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2016, 11:47 AM
  6. Saving .xlsm file to .xlsx
    By BrianAll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2015, 09:23 PM
  7. Saving xlsm file as xlsx while running macro
    By happygilmore in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2012, 02:32 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