Results 1 to 4 of 4

Thread: Save as v2007 explicitly?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular XL Pro's Avatar
    Join Date
    Apr 2002
    Location
    =VLOOKUP("XL Pro",Earth,1,FALSE)
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Save as v2007 explicitly?

    In XL 2016:

    Is there a VBA fileformat for saving an Excel file explicitly as ver 2007? I have a legacy program that can read an Excel 2007 xlsx file, but not 2016.
    Not as Lean
    Not as Mean
    But still a Marine
    Semper Fi

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

  2. #2
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,065
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Save as v2007 explicitly?

    As far as I know a xlsx filetype is the same in 2016 as 2007, are you sure that you weren't saving as an xls filetype when using 2007?
    Last edited by MARK858; May 7th, 2019 at 06:43 PM.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  3. #3
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Save as v2007 explicitly?

    The format is unchanged since Excel 2007, is it not?

  4. #4
    Board Regular XL Pro's Avatar
    Join Date
    Apr 2002
    Location
    =VLOOKUP("XL Pro",Earth,1,FALSE)
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Save as v2007 explicitly?

    Hmmm... we use a program (now pretty old) - Datawatch Monarch v10.5. It's capable of reading Excel files through v2007.
    Our ERP creates Excel XML files, so in my macro I open them and then save them as true .XLSX files. If I save that file with Excel 2007, Monarch can read them. If I save them with Excel 2016, Monarch locks up.
    I understand that .XLSX files are really just "zip" files, so if a file is saved from Excel 2016, there's probably information in there that Excel 2007 just ignores, but crashes Monarch.
    Not as Lean
    Not as Mean
    But still a Marine
    Semper Fi

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •