This week I got the following question in email: I’m writing a COM component in C# that is used in Excel VBA macros. I really need to debug the VBA macro and the C# component at the same time. Is that possible? Absolutely! Here’s the steps:
Now you can debug both the VBA and managed side of your project relatively easily. If you need to debug a native COM component in the same scenario, the only difference with the steps above is not setting the Debugger Type to managed. The default is Auto, which looks at the binary you’re about to debug and if it’s native, it will do native debugging.
Microsoft Azure and Amazon Web Services (AWS) are two of the most popular cloud platforms.…
Cloud management is difficult to do manually, especially if you work with multiple cloud…
Azure’s scalable infrastructure is often cited as one of the primary reasons why it's the…
https://www.youtube.com/watch?v=wDzCN0d8SeA Watch our "Unlocking the Power of AI in your Software Development Life Cycle (SDLC)"…
FinOps is a strategic approach to managing cloud costs. It combines financial management best practices…
Using Kubernetes with Azure combines the power of Kubernetes container orchestration and the cloud capabilities…
View Comments
Afraid I'm slow and need more details. In Step 7 do you add the project containing the managed code to the solution you saved in Step 6? In Step 8 are you starting to debug the managed code or Excel? If it's the managed code, what external program do you tell it to use to start up (since the managed code is a dll it can't be started directly)?
Thanks a lot. A Very useful Solution.