So you want to create a service in C#? well look no further. This article is amazing and will take you through each step clearly and let you know how to make the service. Highly recommend for creating services in the future.

http://www.c-sharpcorner.com/UploadFile/naresh.avari/develop-and-install-a-windows-service-in-C-Sharp/

The following are Error codes used by James’ programs across platforms:

/// Error Code SE-JEHG-0001 = Programer needs to implement XLVBAInitializer method before running code.
/// Error Code SE-JEHG-0002 = User did not provide a destination for StackEm.
/// Error Code SE-JEHG-0003 = VBA constructed name for destination of stackem is invalid

This list is in progress.

So you want really fast internet in the calgary area? Well let me do the leg work for you! These websites offer down and up of at least 150mbs and fiber cables.

http://business.telus.com/en/business/internet/office-internet/?INTCMP=Fibre_Reimagined_BusinessPlans

https://www.shaw.ca/store/internet/internetPackageDetails.jsp?prodId=prod1480004

http://business.shaw.ca/Advanced-Solutions/Internet/Fiber-Gateway

https://shop.shaw.ca/internetplans?SegmentationLinkClicked=true

https://www.axia.com/plans

https://www.broadconnect.ca/internet-solutions/t1/

It has been a mystery on how to get the version number that is in Visual Studio (eg 1.0.1.4) to show. Now I can use a default method to go and get that or have a “version” method in everything that I build. For now, I have a VBA way of getting it. I would prefer to make a method in the c# class called “version” and put it in all my products – that way if I make .version() exposed to the COM/VBA world, I can still get it from VBA. Here is something I found which will do the trick in c#.

So I am having some troubles and am learning too much about old technology. In short – my interface is COM visible to my VBA in my Excel code, but not the class. Crap – add the word public in front of class – fixed it. None-the-less here is a blog of what helped me solve my issue. I WANT (insist) early binding (aka intellisense 🙂 ) (Something close to my issue). Want to know even more … look at the links at the bottom of this article.

First – set up things properly.

• Have a GUID for the interface IMyInterface and on the class MyClassO
• Have the dual interface turned on on the interface and class

Continue reading →