December 2016 – Useful code

VBA – Protect your code – Unviewable+ and the Ribbon Commander

Vitosh Dec 17, 2016 Tagged with unviewable, VBA, vba password protect

Let’s state it straight every VBA developer is happy, when he can protect his own code. The VBE password is not secure protection, everyone with a few free hours and a good internet access can go around it. Thus, I was …

VBA – Protect your code – Unviewable+ and the Ribbon Commander Read more →

C Sharp Tricks, VBA \ Excel

VBA – Add a C# library to a VBA project – Part 2

Vitosh Dec 16, 2016 Tagged with C#, C# library to a VBA project, VBA

After writing the simple part here I think that it is a really good idea to introduce IntelliSense as well 🙂 Something like this in the code: And like this is in the library: The question is always one …

VBA – Add a C# library to a VBA project – Part 2 Read more →

C Sharp Tricks, VBA \ Excel

VBA – Add a C# library to a VBA project

Vitosh Dec 14, 2016 Tagged with C# library in VBA, foreign library VBA, VBA library

For today I was thinking to present an algorithmic problem, but somehow I have decided to show something more useful. It is a Step-by-step instruction for the creation of a C# object in VBA. You know, that references, which you …

VBA – Add a C# library to a VBA project Read more →

C Sharp Tricks

C# – Algorithms – Arpa’s hard exam and Mehrdad’s naive cheat

Vitosh Dec 7, 2016 Tagged with algorithm

As mentioned some times ago, whenever I am looking for a subject to post, the easiest way is to go to Codeforces.com and simply take a problem from the second division. If I manage to solve it from the first …

C# – Algorithms – Arpa’s hard exam and Mehrdad’s naive cheat Read more →

Month: December 2016

VBA – Protect your code – Unviewable+ and the Ribbon Commander

VBA – Add a C# library to a VBA project – Part 2

VBA – Add a C# library to a VBA project

C# – Algorithms – Arpa’s hard exam and Mehrdad’s naive cheat