MS Excel VBO Password Protected Document

[Anonymous]

Hi All, We have a scenario where we are required to update a password protected excel spread sheet, however the current Excel VBO objects we have are unable to recognise that there is even a pop up box for the password to entered on screen. Before we go ahead and create brand new objects for excel to try and fix this issue, could anyone advise if there is a simple modification we can make to the current "Open Workbook" object to recognise the pop up and input the required password. Thanks Craig

[SamanthaShaw]

Hi Craig I've uploaded a modified version of the Excel VBO under a separate post which has an additional action to open a password protected Workbook. See if that works for you. Cheers Sam

[Anonymous]

Thank you Sam, however I am unable to get to the desired attachment in the separate post. Is there anyway you could send me this via email? If so my email is craig.linsdell@xchanging.com Thank you for help. Cheers Craig