|
[2003-05-23] Talking to the outside world in Excel 2003
Being able to code C# with Excel 2003 is great fun but now its time for something a bit more useful.
This next code sample shows how to connect to the internet inside of Excel. The idea is when the workbook opens the code behind the workbook searches for quotes on NASDAQ and then populates the spreadsheet with the data. You can imagine you could have a spreadsheet full of data which is retrieved from data sources on company servers and internet sources etc. As you can see coding for excel in C# allows you to leverage your C# skills and re-use them in the world of Excel spreadsheets.
[2003-05-15] Top Ten Traps in C# for C++ Programmers
In an article for the July 2001 MSDN Magazine I talked about what you need to know to move from C++ to C#. In that article, I mentioned that the syntax of C# is very similar to that of C++ and that the difficult part of the transition was not the language itself but getting comfortable with the managed environment of .NET and understanding the extensive .NET Framework.
[2003-05-08] Using C#.NET in Excel 2003
Aren't you sick and tired of having to use different programming languages for different projects? A few years back I spent nearly 3 years working on Microsoft's Excel VBA support desk. Each day I would take calls from customers asking how to solve different problems using Microsoft Excel and VBA or Visual Basic for Applications.
|
