Results 1 to 8 of 8

Thread: Adapt VBA to save selected slides to a default folder with the original file name

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Contributor
    Joined
    Dec 2018
    Location
    South London
    Posts
    115
    Location
    Hi John, yes the folder C:\MyFolder exists. I tried the code with the \ but still stayed as if the code wasn't there. It puts the selected slides into a new file, as wanted, named Presentation# (without .pptx and not saved); Save As opens the default folder (i.e. Libraries > Documents). Thank you.

  2. #2
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,096
    Location
    It works here.

    Is OldPPT SAVED and is it a pptm?

    You probably need to change SaveCopyAs to a simple SaveAs too.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  3. #3
    VBAX Contributor
    Joined
    Dec 2018
    Location
    South London
    Posts
    115
    Location
    OMG you are a VBA Guru!!!

    THANK YOU!!

    I used:

      Next x
    
      Call NewPPT.SaveAs("C:\MyVault\ " & OldPPT.Name)
      
    Exit Sub
    err:
    MsgBox "Please select slides in an open presentation and then save to your personal vault.  You MUST have a folder C:\MyFolder"
    
    
    End Sub
    Have a wonderful weekend! Will mark this as solved.

Tags for this Thread

Posting Permissions

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