View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kris Kris is offline
external usenet poster
 
Posts: 25
Default Removing Excel password.

Forgot about the WriteResPassword:="".

Change that one to:
WriteResPassword:=Empty to remove that password as well.

Hope this helps,

Kris

-----Original Message-----
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.xlWorkbookNorma l,

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



.

.