View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kris Kris is offline
external usenet poster
 
Posts: 25
Default 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



.