+ Reply to Thread
Results 1 to 4 of 4

Save Copy Filename As Without Including Macros

  1. 10-20-2016, 03:25 PM #1
    mudajaya
    mudajaya is offline
    Registered User
    Join Date
    10-20-2016
    Location
    jakarta
    MS-Off Ver
    2013
    Posts
    2

    Save Copy Filename As Without Including Macros

    Dear All, i have found googling the code below. Help i need save copy filename without including macros, but file master keep is it.
    My excel 2013 version. Sorry my english.
    Thanks for appriciated.. 

    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 10-21-2016 at 12:20 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
    Reply With QuoteRegister To Reply
  2. 10-21-2016, 08:10 AM #2
    Doc.AElstein
    Doc.AElstein is offline
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Please to appreciate I do Give pictures help Explain Friend in Far away land is ..... :)

    Hi mudajaya,
    Welcome to the Excel Forum.

    Please, if you get time, take some time before posting to read the Forum Rules here
    http://www.excelforum.com/forum-rule...rum-rules.html
    http://www.excelforum.com/forums-rules/
    http://www.excelforum.com/showthread...09#post4494031

    _.................................

    Quote Originally Posted by mudajaya View Post
    Dear All, i have found googling the code below. Help i need save copy filename without including macros, but file master keep is it.
    My excel 2013 version. Sorry my english.
    Thanks for appriciated..
    Sorry I no Indonesisch speak can
    You English have very bad understand to is

    Pictures to explain
    Bilder zu erklären
    चित्र को समझाने के लिए
    Gambar untuk menjelaskan
    Bollox

    Try macro recorder


    You have this
    Please Login or Register  to view this content.
    You want to Save As so that macros are saved ( .xlsm )

    _._______________________________________________
    _..................................................................................................................................................
    _1) Start Macro recording

    MacroRecorderDevelopmentTools123.JPG
    http://imgur.com/TrzSDWq

    Or
    MacroRecorderView1234.JPG
    http://imgur.com/a/SZz8B

    _..................................................................................................................................................
    _2 ) Save with required extension

    SaveAs12.jpg
    http://imgur.com/xrx2LHI

    _.........................

    For Example, Save as .xlsm ( With macros )
    SaveWithMacros.jpg
    http://imgur.com/LlUjBQo

    _......................................................................................
    _3 ) Stop macro recording

    StopButton.JPG
    http://imgur.com/4Wgqy8o

    Or
    StopDevelopmentTools12.JPG
    http://imgur.com/VWDQ7pK

    Or
    StopView12.JPG
    http://imgur.com/9jGAVrN
    _..................................................................................................................................................

    _4 ) Save File

    _..................................................................................................................................................

    _ 5) Close File

    _..................................................................................................................................................
    _ 6) Open File and Enable macros on opening

    EnableMacroOnOpening.jpg
    http://imgur.com/3jqtbZv

    _..................................................................................................................................................
    _ 7 ) Select macro and Option to Work on it

    DevelopmentToolsWorkOnMacro123.JPG
    http://imgur.com/I91Yckx

    Or

    ViewWorkOnMacro1234.JPG
    http://imgur.com/4jovFhV

    ( Or with Keyboard Short Cut
    Alt + F8
     )
    _..................................................................................................................................................
    _8 ) Modify original code by Copy and Paste required part of code from macro recording

    macro1.JPG
    http://imgur.com/QbGmahc

    _ 8a) Copy part of Code: ( Highlight and Ctrl+C )

    Please Login or Register  to view this content.
    _.....................................

    _ 8 b) Paste in your code: (Highlight and Ctrl+V)

    Please Login or Register  to view this content.
    _.....................................................................................................
    God be with you sir

    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
    Reply With QuoteRegister To Reply
  3. 10-23-2016, 10:20 PM #3
    mudajaya
    mudajaya is offline
    Registered User
    Join Date
    10-20-2016
    Location
    jakarta
    MS-Off Ver
    2013
    Posts
    2

    Re: Save Copy Filename As Without Including Macros

    hi thanks for your help. Ill try it out when I get relaxed
    Reply With QuoteRegister To Reply
  4. 10-24-2016, 02:52 AM #4
    Doc.AElstein
    Doc.AElstein is offline
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Save Copy Filename As Without Including Macros. Rolly Eyes ;) and brocken English Wonks

    Quote Originally Posted by mudajaya View Post
    ... try it out when I get relaxed..

    Me thank you the feedback, Good to have is welcome.

    Good Luck!
    Alan
    Last edited by Doc.AElstein; 10-24-2016 at 02:53 PM. Reason: Any old Bollox. get relaxed later oh er missus
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Input Filename to copy, rename and save to directory
    By Tellm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 05:58 AM
  2. Save a copy of the workbook including only sheets with values in a certain cell
    By Melisendk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2013, 08:47 AM
  3. Can the message 'FileName.xlsm' is read-only. To save a copy, click OK, .. be suppressed ?
    By zorrozac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2012, 05:20 PM
  4. Copy worksheet including named ranges not including macros
    By urungus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-07-2009, 01:38 PM
  5. Copy entire worksheet including all Macros and VBA Code
    By alanda in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-22-2008, 04:03 PM
  6. [SOLVED] Auto save file copy with unique filename
    By Allen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2006, 03:25 PM
  7. [SOLVED] Date + Filename using save copy as
    By SKelley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1