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.
Directory:
> Articles > Application Development
Date: 2003-05-23
|
My NAnt and NUncle
I was looking for a nice and easy way to automatically build my projects and I didn't have to look far to find NAnt, a variant of Ant, a build tool for Java projects. If you want to cheat and read ahead, check out http://nant.sourceforge.net but don't get too comfy, jack, there's not much out there to guide you along. I'm going to save you some precious time and help provide you with a starter script... because believe me, you'll be hard pressed to find some good examples on the web. Don't really expect much out of the examples provided by the good folks down at NAnt, but do dig into their NAnt.build - it contains secrets that you won't find anywhere.
Directory:
> Articles > Application Development
Date: 2003-05-19
|
Porting Your MIDlets to New Devices
It is unnecessary to say that many developers are using J2ME to develop their games and enterprise applications to take advantage of the 'write once, run anywhere' paradigm. Who am I do bash this very noble intention, but phones unlike many other types of computer, have no uniform set of memory and storage parameters that improves over time.
Directory:
> Articles > Application Development
Date: 2003-05-19
|
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.
Directory:
> Articles > Application Development
Date: 2003-05-15
|
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.
Directory:
> Articles > Application Development
Date: 2003-05-08
|
|
|
