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

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" wrote in message
...
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

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" wrote in message
...
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