topic Hi Sam, in Product Forum

Modified Excel VBO - with open password protected Workbook

SamanthaShaw — Fri, 30 Oct 2015 16:15:00 GMT

Attached should be a modified Excel VBO with an extra action to open a password protected Workbook. Please note that this is supplied "as is" and is not an official part of the Blue Prism product. There are enhancement requests also logged to add further functionality of this nature and more to the Excel VBO that ships with the product. Sam

Hi Sam,

ColmGoggin — Mon, 11 Apr 2016 18:54:00 GMT

Hi Sam, This VBO doesn't appear to be attached to post. Can you send it to me at colm.goggin@zurich.ie ? Thanks

Hello Sam,

Anonymous — Mon, 26 Sep 2016 19:41:00 GMT

Hello Sam, Could you share this VBO with me as well? paul.sauvage@voyagersolutions.com Many thanks,

Hi Sam,

artur_karwowski — Tue, 29 Nov 2016 19:48:00 GMT

Hi Sam, Could you please send the early acccess version of this VBO to artur.karwowski@accenture.com Thank you, Artur

Hello Sam,

SantiagoRodrigu — Tue, 06 Dec 2016 23:37:00 GMT

Hello Sam, Could you please share with me the Excel VBO file? my email is santiago.t.rodrigue@aexp.com I would really appreciate it, Regards, Santiago.

Hi Sam,

RoopaBorkar — Thu, 08 Dec 2016 17:22:00 GMT

Hi Sam, Can u please share modified ms excel vbo to me as well. Email id : roopa.borkar@mphasis.com Regards Roopa

Hi,

Christopher — Sun, 18 Jun 2017 09:23:00 GMT

Hi, Can any off you forward the VBO to christopher.diggs@teliacompany.com Thank you

Hi,

LasseGravesen — Thu, 22 Jun 2017 16:11:00 GMT

Hi, Can any of you forward the VBO to lasse.v.gravesen@consult.nordea.com

Hi Sam,

AnilKurapati — Wed, 28 Jun 2017 15:03:00 GMT

Hi Sam, Could you please share with me the Excel VBO file? my email is anil.kurapati@cgi.com Thanks, Anil.

Can someone please post the

NiallFee — Thu, 13 Jul 2017 17:56:00 GMT

Can someone please post the XML from the VBO for this? It would save everyone having to ask for an email copy... Thanks

I amended the code in the

NiallFee — Fri, 14 Jul 2017 15:21:00 GMT

I amended the code in the existing 'Open Workbook' action as follows where 'password' is a reference to a Password Data Item Input: Dim wb as Object = GetInstance(handle).Workbooks.Open(filename, Type.Missing, Type.Missing, Type.Missing, password) name = wb.Name wb.Activate()

Thanks for posting this

DaraghMonaghan — Mon, 17 Jul 2017 14:33:00 GMT

Thanks for posting this niallfee. I just recently figured out the code myself and came here to post it. I'm following more or less the same logic myself but lack knowledge of Visual Basic and I'm not sure what the function of the Type.Missing objects. Would you be able to explain these? In addition to the above, I included WriteResPassword in my own, if in the case of files having separate write/read credentials. These can be set to whatever data item inputs you need. As a bonus, there's no issue using the amended code if the files you are opening do not have password access enabled. Dim wb as Object = GetInstance(handle).Workbooks.Open(filename,Password:=(Password),WriteResPassword:=(Password)) name = wb.Name wb.Activate()

Hi Daragh, I think the Type

NiallFee — Tue, 18 Jul 2017 13:58:00 GMT

Hi Daragh, I think the Type.Missing just invokes the default value for the parameter at that position. I'm very new to this too so it probably isn't the best way to write it! My code is just using filename for the first parameter, then using Type.Missing to get the default for the next 3 parameters and then using password for the fifth parameter. I guess your approach is explicitly calling out and assigning the password parameters rather than going through the list until it gets to them like mine. https://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel

OK I think I get where you're

DaraghMonaghan — Tue, 18 Jul 2017 14:53:00 GMT

OK I think I get where you're coming from. Thanks!

Hi

HamidSabaro1 — Mon, 31 Jul 2017 18:02:00 GMT

Hi can someone forward the VBO to hamid.sabaro@teliacompany.com Thanks in advance!

If anyone could link the VBO

IL — Wed, 15 Nov 2017 20:10:00 GMT

If anyone could link the VBO that would be great! Thanks!