Consulting

Results 1 to 7 of 7

Thread: Powerpoint 2000 dlgSaveAs Problems

  1. #1
    VBAX Newbie
    Joined
    Dec 2007
    Posts
    4
    Location

    Exclamation Powerpoint 2000 dlgSaveAs Problems

    I have a userform in Powerpoint 2003 that asks the users to save thier documents with a specific naming convention. This works perfectly with Powerpoint 2003 but alas our network still has many users on Powerpoint 2000. I tried to use the same code in Powerpoint 2000 but a portion of it will not work. The probmatic element is the SaveAs dialog box will not open.

    The code used in Powerpoint 2003 is:

    With Application.FileDialog(msoFileDialogSaveAs)
    Dim dlgSaveAs As FileDialog
    Set dlgSaveAs = Application.FileDialog(_
    Type:=msoFileDialogSaveAs)
    dlgSaveAs.InitialFileName = FN 'FN is entered by the user
    dlgSaveAs.Show
    dlgSaveAs.AllowMultiSelect = True
    dlgSaveAs.Execute
    End With
    The problem seems to be that Powerpoint 2000 does not recognise the above items.

    Any Help would be appreciated.
    Last edited by Aussiebear; 04-28-2023 at 08:19 PM. Reason: Added code tags

  2. #2
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    Have a read of Shyam Pillai page.
    http://skp.mvps.org/ppt00043.htm
    Cheers
    Andy

  3. #3
    VBAX Newbie
    Joined
    Dec 2007
    Posts
    4
    Location
    Andy,
    Sorry for the delay in any response.
    Firstly thanks for the link. I have however tried this and although the Save As dialog box opens it does not action the save function when you click on the save button (nothing happens) (I have modified the code so the message box does not show)
    Grateful for any other ideas?

    Regards

  4. #4
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    That would be correct according to the instructions on the page.

    ProcessSelection merely determines the filename that was provided and displayes it in a message box.
    In the example the information is simply displayed.
    You would need to use the SaveAs method with the filename provided via the dialog.
    Cheers
    Andy

  5. #5
    VBAX Newbie
    Joined
    Dec 2007
    Posts
    4
    Location
    Thanks again
    I have managed to input the filename into the Save As Dialog box and save it to the desired location. However I have a userform which forces the user to save the file to a certain namining convention. Do you know of any way to insert this into the FileName box on the SAVE As Dialaog box ( I only manage to show the origional document name)
    The code used for this in 2003 is below

    dlgSaveAs.InitialFileName = FN 'FN is entered by the user

    Many Thanks

  6. #6
    MS Excel MVP VBAX Mentor Andy Pope's Avatar
    Joined
    May 2004
    Location
    Essex, England
    Posts
    344
    Location
    That property is only available in the later OM.

    I do not know of a way to set the filename prior to displaying.

    Is the filename convention such that you even need to ask the user what to save as?
    Cheers
    Andy

  7. #7
    VBAX Newbie
    Joined
    Dec 2007
    Posts
    4
    Location
    Andy,
    Unfortunatally the file name needs to be transfered to the FileName box in the SaveAs Dialog box.
    The user form has drop down boxes for the user to insert the file version, classification and the date is added automatically. The user is prompted to add a file title and the final format is as follows:
    YYYYMMDD-Title-Version-Classification
    The user then select a Save button the user form and this opens the SaveAs Dialog box. From here the user can navigate to the correct area on the electronic file plan and save the document. This is why the FileName in the Dialog box must represent the filename created from the User Form. Developments have made this possible in Powerpoint 2003 however if it is not possible in 2000 then I will have to convince my boss that it is time to update my 1000+ users to 2003.

    Regards

Posting Permissions

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