Hi.
 I was wondering if someone from this group could possibly help me.

I am trying to open a password protected excel application from within
my vb app.

I have tried various code samples such as

Dim my xlapp as excel.application
set myxlapp = getobject("myspreadsheet.xls")
myxlapp.open workbooks("myspreadsheet", "thepassword")

didn't work

tried

myxlapp.open workbooks("myspreadsheet", password:"thepassword")

tried

myxlapp.open workbooks("myspreadsheet", password: = "thepassword")

nope.

Can someone please help me out with this?