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



.

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



.

.

Hi Tim,

Have you tried Kris's suggestion?
If you still have any concern on this issue, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks,

All is resolved now. I was due to the fact the Workbook was protected.

Tim

""Peter Huang"" wrote in message
...
Hi Tim,

Have you tried Kris's suggestion?
If you still have any concern on this issue, please feel free to post
here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no
rights.

Hi Tim,

I am glad that the problem is resolved.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.