Welcome to MSDN Blogs Sign in | Join | Help

April 2008 - Posts

Wednesday, April 30, 2008 1:41 PM

Append Multiple Text Files into a Worksheet without Code

Today's author: Mark Gillis, an Excel and SharePoint writer, who's been through six versions of Office, survived to tell the tale, and picked up a thing or two along the way. Excel doesn't have an easy way to append multiple text files into one worksheet
Posted by Joseph Chirilov | 9 Comments
Filed under:

Attachment(s): TextFilesSalesData.zip
Tuesday, April 22, 2008 3:37 PM

Improving Sheet Selection

Today's author: Sam Radakovitz, a Program Manager on the Excel team that enjoys creating VBA applications in Excel. A bit ago I got a question through email asking if we could change the 'grid selection color' in Excel. Or at least I called it 'grid selection
Posted by Joseph Chirilov | 14 Comments
Filed under:

Attachment(s): Selection-Shapes-and-Userform.zip
Friday, April 18, 2008 2:50 PM

Building the Excel Media Player – Part 3

Last post we talked about how to use Excel as a flexible development environment and touched on how to use ActiveX Controls to enhance your solution and using tables programmatically to manipulate data. In this post we are going to drill into how to add
Posted by Joseph Chirilov | 1 Comments
Filed under: ,
Wednesday, April 16, 2008 8:31 PM

Building the Excel Media Player – Part 2

Last post we talked about how to use Excel as a flexible development environment and touched on the benefits of using Office graphics to build your UI. This post goes into how to use ActiveX controls in Excel and how to contain and manipulate data in
Posted by Joseph Chirilov | 2 Comments
Filed under: ,
Monday, April 14, 2008 5:39 PM

Building the Excel Media Player – Part 1

Today's author, Jon Adams, a Tester on the Excel team. A copy of the spreadsheet discussed in this post can be found as an attachment at the bottom of this post. As you are probably well aware, Excel is a very versatile tool and is often used in ways
Posted by Joseph Chirilov | 5 Comments
Filed under: ,

Attachment(s): MediaPlayer.xlsm
Thursday, April 10, 2008 3:46 PM

Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?”

We sometimes get mails from our customers claiming to have found a calculation error in Excel, when in fact the calculation isn't wrong, but the side effects of binary floating point precision make it seem that way. Today's author: Jessica Liu, a Program
Posted by Joseph Chirilov | 13 Comments
Wednesday, April 02, 2008 11:44 AM

Statistics and Business Data: Detecting Unexpected Values

Today's author, Gabhan Berry, a Program Manager on the Excel team. A copy of the spreadsheet discussed in this post can be found as an attachment at the bottom of this post. Introduction When faced with a table of data, what kind of techniques do we employ
Posted by Joseph Chirilov | 3 Comments
Filed under:

Attachment(s): Binomial Distribution.xlsx
Wednesday, April 02, 2008 9:11 AM

Office Open XML, a.k.a. IS 29500

As everyone who has followed this blog already knows, we introduced a new file format with Office 2007 (and Excel 2007) with the extension .xlsx called Office Open XML (OOXML). Microsoft submitted the new file format to Ecma International, and in December
Posted by Joseph Chirilov | 0 Comments
Filed under:
 
Page view tracker