+ Reply to Thread
Results 1 to 2 of 2

Save as different file type

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Save as different file type

    I almost have my macro the way I want it: when I close my main document, if unsaved it prompts me to save, then saves a copy, and if I've already saved, it saves a copy when I close. However, there's 2 things I'd like some help with:

    1) When the "SaveAs2" occurs I'd like it to save as a .DOCX instead of a .DOCM (the draft copy doesn't need the code).
    2) Currently if I try to close and haven't saved, my macro asks if I want to save, then WORD asks if I want to save. I'd love to find a way to get around the double check.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Save as different file type

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

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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] VBA save as file type
    By dantray02 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-30-2016, 01:14 PM
  2. File Save As on Cell Value and File Type not working
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2016, 06:10 PM
  3. SAVE AS with New FIle type
    By damaniam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2015, 03:17 AM
  4. Macro needed to open "File Save As" and change save file type
    By blainerhett in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2014, 02:40 PM
  5. Save as macro that specifies file type, file location and takes file name from three cells
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-13-2013, 10:09 PM
  6. Save As File Type
    By swedish max in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2006, 06:40 AM
  7. why cant i see .csv as save file type
    By Adie in forum Excel General
    Replies: 3
    Last Post: 07-19-2005, 02:05 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