Posted to microsoft.public.excel.programming
|
|
Removing Excel password.
Hello Tim,
Change:
Password:=""
To:
Password:=Empty
Hope this helps,
Kris
-----Original Message-----
Hi,
I am using the following code ( VB.NET) to try and
remove a password from a
Excel Workbook.
objWB.SaveAs(Filename:=objWB.FullName,
FileFormat:=Excel.XlFileFormat.xlWorkbookNormal ,
Password:="",
WriteResPassword:="", ReadOnlyRecommended:=False,
CreateBackup:=False)
But it is not working.
I can set different passwords, but when I try to remove
it, it does not
work.
Any ideas
.
|