Problem using code involving Excel VBO - 'It may be inaccessible due to its protection level'

[MichelleBest]

I'm creating an action that will clear existing data from a range of cells in Excel. I've used a Code tool and tried it with the code on this site.



When I test the code, I get error messages on 'Columns' and 'GetWorkbook' saying 'they are not declared. It may be inaccessible due to its protection level.' 



I used the info on this site to add Microsoft.VisualBasic.dll as an entry in the "External References" section of the Code Options tab. Microsoft.VisualBasic was already entered under 'Namespace imports'.



It didn't work though... Is there another dll I should add for these functions? Thank you.

------------------------------
Michelle
------------------------------

[MichelleBest]

I added the code as a new page within the Excel VBO and it works like a charm now. I hope that was the way I was supposed to do it... 🙂

------------------------------
Michelle
------------------------------

[ewilson]

@MichelleBest,

Most, if not all, of the VBOs Blue Prism posts to the Digital Exchange (as well as those that are included in the installer) are released under the MIT License. That is an open-source license that says you're pretty much free to do what you want with those objects so long as you maintain any Blue Prism copyright. So you're good.

Cheers,
​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------