+ Reply to Thread
Results 1 to 3 of 3

Password on Save As

Hybrid View

Guest Password on Save As 06-16-2005, 07:05 PM
Guest Re: Password on Save As 06-16-2005, 09:05 PM
Guest Re: Password on Save As 06-17-2005, 01:05 PM
  1. #1
    Ashman
    Guest

    Password on Save As

    Hi all,

    I am wanting a user to be able to select where the file is saved and the
    code I have used is:

    Application.Dialogs(xlDialogSaveAs).Show

    But does anyone know how I can attached a password to this file after the
    user has selected where they want to save the file and what they want to call
    it?

    The saveas function allows this, but I think it needs to know what the file
    is called and where it is to be saved.

    Any help would be much appreciated.

    Thanks

    Ashman

  2. #2
    Robin Hammond
    Guest

    Re: Password on Save As

    Ashman,

    Have a look at GetSaveAsFilename in the VBA help file. Once you have the
    name, use the SaveAs method with a password.

    Robin Hammond
    www.enhanceddatasystems.com

    "Ashman" <Ashman@discussions.microsoft.com> wrote in message
    news:E2BFBB71-BD3E-4513-B511-0913A5C38F2F@microsoft.com...
    > Hi all,
    >
    > I am wanting a user to be able to select where the file is saved and the
    > code I have used is:
    >
    > Application.Dialogs(xlDialogSaveAs).Show
    >
    > But does anyone know how I can attached a password to this file after the
    > user has selected where they want to save the file and what they want to
    > call
    > it?
    >
    > The saveas function allows this, but I think it needs to know what the
    > file
    > is called and where it is to be saved.
    >
    > Any help would be much appreciated.
    >
    > Thanks
    >
    > Ashman




  3. #3
    Ashman
    Guest

    Re: Password on Save As

    Cheers, many thanks works well

    Ashman

    "Robin Hammond" wrote:

    > Ashman,
    >
    > Have a look at GetSaveAsFilename in the VBA help file. Once you have the
    > name, use the SaveAs method with a password.
    >
    > Robin Hammond
    > www.enhanceddatasystems.com
    >
    > "Ashman" <Ashman@discussions.microsoft.com> wrote in message
    > news:E2BFBB71-BD3E-4513-B511-0913A5C38F2F@microsoft.com...
    > > Hi all,
    > >
    > > I am wanting a user to be able to select where the file is saved and the
    > > code I have used is:
    > >
    > > Application.Dialogs(xlDialogSaveAs).Show
    > >
    > > But does anyone know how I can attached a password to this file after the
    > > user has selected where they want to save the file and what they want to
    > > call
    > > it?
    > >
    > > The saveas function allows this, but I think it needs to know what the
    > > file
    > > is called and where it is to be saved.
    > >
    > > Any help would be much appreciated.
    > >
    > > Thanks
    > >
    > > Ashman

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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