Thanks for all the inputs. I got the same error as RPA_1's. "Open Workbook" code has changed in the later versions of MS Excel VBO.
My solution was to create another page "Open Protected Workbook" and I used the same code as mentioned in initial posts.
Another question,
How do I save this file without a password?