February 2011 - The Excel Team Blog

In today's post, programmer writer Eric Schmidt shows how he took rows in an Excel workbook and generated text files from the data in the rows using Visual Studio 2010, Visual Basic, .NET 4, and Excel 2010. ...( read more ) Read More...

In today's blog post, learn how programmer writer, Eric Schmidt, uses Visual Basic code to pull data from text files in a shared folder and then add that data programmatically into an Excel workbook. ...( read more ) Read More...

You may remember this graphic from my previous post: It was totally staged. A fabrication. Well, the PowerPoint templates are the original files – so it wasn’t completely faked. But I added all of the text files back into the folder in order to create the image. As I worked on the previous post, I realized that I should include an image that visually demonstrates what I needed to accomplish. Yet, by the time I wrote the post, I had already handed off those templates and all the (now unnecessary)...

If you're like me, and you're still trying to get started on your New Year's resolutions, hope is not lost. If you made a resolution around getting your budget set up or organizing your monthly financial expenses, you're in luck. There are some great Excel templates and videos available to show you how to turn your monthly budget spreadsheet into a work of art, all in under 5 minutes! And if you don't already have a budget spreadsheet, there are even some great templates to get...