Consulting

Results 1 to 3 of 3

Thread: Save a new copy of file "without" the macro

  1. #1

    Save a new copy of file "without" the macro

    I have a master ppt file that I use for updating. I have a macro that breaks all the links and saves a new copy for distribution. Is there a way to save the new copy so it does not include the macro in the master file? Or, delete the macro from the new file and resave? I'd like to avoid getting the macro warning on the new copy of the file for anyone that opens it.

  2. #2
    VBAX Contributor
    Joined
    May 2008
    Posts
    198
    Location
    Hmm, don't know what happened to the response I posted earlier. Seems to have disappeared from the forum.

    Here's the code I use to remove a few specific modules from a presentation:
    [VBA]MasterFile.VBProject.VBComponents.Remove.VBComponents("ModuleToDelete")
    [/VBA]
    Where 'MasterFile' is a reference to your master PPT file, and 'ModuleToDelete' is the name of the module you want to delete.

  3. #3
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,094
    Location
    I would put the code in an addIn or at least in second presentation.

    There are instructions on www.pptfaq.com on creating a simple addin with a toolbar.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

Posting Permissions

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