Open and Save as a pptx file with dialog box

  • Hi! I want to open a pptx file and save as it directly with a dialog box or a prompt shows up allowing the user to choose a location to save it and what file name.


    I do not want to open the pptx file so I added the .visible false and it does not work. other than that, removing that line of code, I can't still save as my pptx file


    I tried this code but to no luck


    Any help will be appreciated! Thank you.

  • There was a missing comma in this line and I've changed the FileFormat. I can't test this though


    Code
    objPPT.ActivePresentations.SaveAs Filename:=fileSaveName, FileFormat:=ppSaveAsDefault
  • Have you tried with the ppt visible?


    Are you getting an error message?

    I removed the ppt visible because it does not really work.
    I am still to find another way to make it work :(


    and yes I am getting an error with this line; objPPT.ActivePresentations.SaveAs Filename:=fileSaveName, FileFormat:=ppSaveAsDefault

  • I think I've found what was wrong. Try this




    Your code needed to save the presentation - pptDoc

    Code
    pptDoc
    Code
    pptDoc
  • I think I've found what was wrong. Try this




    Your code needed to save the presentation - pptDoc

    Code
    pptDoc
    Code
    pptDoc

    THANK YOU SO MUCH FOR THIS, SIR! I kinda get it working.


    This automatically saves the file to a path made by the user.

    My only problem now is after the saveas, the file is not opened.


    Any help on how can I open the newly saveas file?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!