Unable to open Excel with macro

[guptasourav]

I am opening an Excel file on my server, and saving it with some other name and then trying to coping the new excel to my local machine.
If i use a simple Excel(without macro but with password) it works properly but if i use a macro and make the excel password protected then it does not allow me to open it.


It does not give any exception but on reaching to "oWB = oXL.Workbooks.O pen(" it hangs up.


Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load
Try
Dim oXL As New Excel.Applicati on
Dim oWB, oWBNew As Excel.Workbook

oWB = oXL.Workbooks.O pen("\\infpu050 19\KnowledgePla nner\VashiProje cts\CX_ADM\PDLC \Coding\SOURCE\ CVXGENERATEEXCE LFORTRACK\RESOU RCES\Filebag\Fi nance94027.xls" , , , , "Password")

oWB.SaveAs("D:\ excelwb\Finance 94027_1.xls")

oWB.Close()
oXL = Nothing

Dim OXL2 As New Excel.Applicati on

Response.Clear( )
Response.Conten tType = "Applicatio n/vnd.ms-excel"
oWBNew = OXL2.Workbooks. Open("\\infpu05 019\excelwb\Fin ance94027_1.xls ", , , , "Password")

oWBNew.Save()
oWBNew.Close()
OXL2 = Nothing


Catch ex As Exception
Response.Write( ex)
End Try

End Sub