Add password protection to excel file

Does anyone know if there is a way to use foxpro 9 to add password
protection to an excel 2003 file? I would like to create a quick form
to enter a password and a file name and then have the app password
protect the file.

Thanks!

Michel
Tue Oct 24 11:01:55 CDT 2006

in object browser, open excel.exe, then look for "password" ; you'll find
methods and properties...

--
Michel Lévy

Pensez à vous inscrire aux Rencontres AtoutFox 2006 !
http://www.atoutfox.org/dates_rencontres_atoutfox_2006-programme.asp

--
"deciacco" <eugenio@iatmgu.com> a écrit dans le message de news:
1161703779.964322.55350@b28g2000cwb.googlegroups.com...
> Does anyone know if there is a way to use foxpro 9 to add password
> protection to an excel 2003 file? I would like to create a quick form
> to enter a password and a file name and then have the app password
> protect the file.
>
> Thanks!
>

Cindy
Tue Oct 24 11:18:41 CDT 2006

Hi Eugenio,

I haven't password protected a workbook but have protected and unprotected
sheets:

oExcel.oBook.Sheets("Division Budget").Protect(cPassword, , .T.)
oExcel.oBook.Sheets("Division Budget").Unprotect(cPassword)

*-- Sheet is protected with no password. Prevents accidental changes.
oExcel.oBook.Sheets("Division Budget").Unprotect()

Note that with a sheet you can choose which cells are protected and which
are not. This is ideal when the sheet is a template with built-in formulas.


--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@cindywinegarden.com


"deciacco" <eugenio@iatmgu.com> wrote in message
news:1161703779.964322.55350@b28g2000cwb.googlegroups.com...
> Does anyone know if there is a way to use foxpro 9 to add password
> protection to an excel 2003 file? I would like to create a quick form
> to enter a password and a file name and then have the app password
> protect the file.
>
> Thanks!
>

SandorHajdu
Thu Oct 26 03:21:01 CDT 2006

Hi,

try this: oExcel.ActiveWorkbook.SaveAs(filename,-4143,yourpassword,"",0,0)
--
Sandor


"deciacco" wrote:

> Does anyone know if there is a way to use foxpro 9 to add password
> protection to an excel 2003 file? I would like to create a quick form
> to enter a password and a file name and then have the app password
> protect the file.
>
> Thanks!
>
>