Hi All,

Can anyone assist me in the code I need to write to password protect a file
so that the user is prompted for a password when attempting to open the file.

Kind Regards,

Terry

Hi Terry

no code needed, save the file using file save as ... choose tools in the
dialog box toolbar, general options - and you can then set a password to
open and /or a password to modify.


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Terry" wrote in message
...
Hi All,

Can anyone assist me in the code I need to write to password protect a
file
so that the user is prompted for a password when attempting to open the
file.

Kind Regards,

Terry

Hi Julie,

The excel file is created in an automated process from DTS within MSSQL 2000.

Thanks,
Terry

"JulieD" wrote:

Hi Terry

no code needed, save the file using file save as ... choose tools in the
dialog box toolbar, general options - and you can then set a password to
open and /or a password to modify.


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Terry" wrote in message
...
Hi All,

Can anyone assist me in the code I need to write to password protect a
file
so that the user is prompted for a password when attempting to open the
file.

Kind Regards,

Terry

Terry,

following opens a file,
if it doesnt have a password then saves it WITH the password
then closes it.

error handling (file should exist etc, pw cannot be zero lenght..
to be added.

Sub OpenAndSaveWithPW(strFullPath$, strPW$)
With Workbooks.Open(strFullPath, Password:=strPW)
If Not .HasPassword Then
Application.DisplayAlerts = False
.SaveAs .FullName, Password:=strPW
Application.DisplayAlerts = True
End If
.Close
End With
End Sub





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Terry wrote :

Hi Julie,

The excel file is created in an automated process from DTS within
MSSQL 2000.

Thanks,
Terry

"JulieD" wrote:

Hi Terry

no code needed, save the file using file save as ... choose tools
in the dialog box toolbar, general options - and you can then set a
password to open and /or a password to modify.


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Terry" wrote in message
...
Hi All,

Can anyone assist me in the code I need to write to password
protect a file
so that the user is prompted for a password when attempting to
open the file.

Kind Regards,

Terry