How do you save a file as xlsx when its is received as an xlm file

Posted on 2012-08-30
Last Modified: 2012-09-03
I receive a number of files each day in xlm.  I wanted to via VBA save these files as xlsx.  Any suggestions on an approach ?
Question by:upobDaPlaya
    LVL 18

    Assisted Solution

    If the spreadsheet contains VBA code than you can't save it as an *.xlsx and retain the code.

    In this latest version of Excel, *.xlsm are for spreadsheets that have VBA code and *.xlsx for those without...

    LVL 100

    Assisted Solution

    Are you looking for an automated solution or manual?

    Open the spreadsheet
    Click FILE --> SAVE AS
       CHoose the appropriate file type
       Change the name if desired

    LVL 32

    Accepted Solution

    to build on mlmcc manual method,  if you are processing the files using a macro from a different workbook...

        ActiveWorkbook.SaveAs Filename:="C:\ee\Q_27848834-Sample1.xlsx", _
                FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

    Open in new window


    Author Closing Comment

    Thanks all

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now