+ Reply to Thread
Results 1 to 2 of 2

Save copy without macros while saving main workbook

  1. #1
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Save copy without macros while saving main workbook

    Hello,
    Im trying to save a copy of a macro enabled workbook in another location when i save my macro enabled workbook.
    Ive been working with the following code
    Please Login or Register  to view this content.
    I cant seem to get it to work and keep crashing excel.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,301

    Re: Save copy without macros while saving main workbook

    There is no such syntax form of "SaveAsCopy" like "SaveCopyAs Filename:=, FileFormat:=, CreateBackup:=False"
    Try this:
    Please Login or Register  to view this content.

+ 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] Switch between Internet Explorer & Main Macros WorkBook
    By illinifan16 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2016, 05:52 PM
  2. Save As Dialogue - Default to Saving Without Macros
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2016, 08:34 AM
  3. Automatically Copy Data from Workbook - Main Workbook
    By BigBobBobson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2015, 06:59 AM
  4. [SOLVED] Need to Copy/Save Entire Workbook as .XLSX but Keep Macros Running
    By bryanmarks in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-29-2014, 07:43 PM
  5. Macros running when I save a different copy of excel workbook
    By chidmas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2013, 12:49 PM
  6. Save a copy of workbook without macros
    By nnram123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2009, 07:45 AM
  7. automatically save a copy of the workbook when saving or closing it
    By excel1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2008, 08:06 AM

Tags for this Thread

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