Access 2013 not opening Protected Excel workbook. - Microsoft Community

since changing office 2013, 2003, piece of vba in access recursively opens protected workbook, enters data it, , saves workbook, protected, under new name, no longer works.  

i have tried hours solve , have tried lot of remedies.  my search-fu seems have escaped me.

        set oexcel = createobject("excel.application")
        oexcel.displayalerts = false
        oexcel.automationsecurity = msoautomationsecurityforcedisable
        set obook = oexcel.workbooks.open("f:\1surveyblank.xlsx", )

the 'set obook = ' seems problem, haven't been able resolve it.

since change, snippet generates interactive input requested password, telling me reserved me. 

this code hundreds of these workbooks @ time, (well, used to)

the userinterfaceonly keyword comes not exist,

the password:="password' option not remove interruption,

the readonly:=false option nothing.

anyone?

this question better asked in excel forum. that's because you're using excel object library. use it, access or elsewhere, matters not @ all.

also, seem have left out critical information in code fragment.

Office / Access / Windows 8 / Office 2013