Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Programmability   (RSS)
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
Wednesday, March 05, 2008 12:45 AM

Handling Workbook Dependencies using Excel Services

Today's author, Sanjay Kulkarni, a Program Manager on the Excel Services team. We have heard from several customers about scenarios where they have workbook dependencies. So the output of one workbook is used in other workbooks for calculations. The dependencies
Posted by Joseph Chirilov | 3 Comments
Attachment(s): WorkbookDependencies.zip
Monday, February 04, 2008 2:44 PM

New Excel Blog in Town

Gabhan Berry, a Program Manager on the Excel team, has just started up a new blog devoted to Excel programming . To quote his first blog post : Starting from today, I'll be blogging about all things related to programming with Excel. From addins to automation;
Posted by Joseph Chirilov | 7 Comments
Filed under:
Wednesday, January 16, 2008 10:28 PM

Clarification on VBA Support

Following MacWorld earlier this week, there has been some inaccurate information circulating online regarding VBA support in Office for Windows. While it’s true that VBA isn't supported in the latest version of Office for the Mac and the VBA licensing
Posted by Joseph Chirilov | 43 Comments
Filed under:
Wednesday, January 16, 2008 5:24 PM

The 2008 Office Developers Conference

A bit of older news but worth mentioning again for those that might be interested. The Office Developers Conference (ODC) is being held this year in San Jose, California and will take place February 10-13. To quote the site: "ODC 2008 is the premier event
Posted by Joseph Chirilov | 2 Comments
Filed under:
Monday, December 24, 2007 6:01 AM

Integrating Excel (Services) and PowerPoint with the Microsoft SDK for Open XML Formats

Today's author: Danny Khen, a program manager who works on both the Excel and Excel Services teams. What is this about? Office 2007 introduced new default file formats – Open XML. Excel, Word and PowerPoint take advantage of them. One of the nicest things
Posted by David Gainer | 11 Comments
Wednesday, December 12, 2007 3:17 PM

Switching Data Sources in Excel 2007

Today’s Author: Howie Dickerman, a program manager on the Excel team. Howie is going to discuss different ways to change data sources in Excel 2007. Prerequisite: This post assumes that you have read the blog post entitled “Managing External Database
Posted by David Gainer | 3 Comments
Tuesday, September 11, 2007 10:07 PM

Title: Excel 2007 XLL SDK is released!

Today’s author: Danny Khen, a program manager on the Excel team who works in the areas of programmability and business intelligence. Danny worked with a number of people, both internal and external, on the Excel 2007 XLL SDK. The Microsoft Office Excel
Posted by David Gainer | 3 Comments
Filed under:
Tuesday, August 28, 2007 9:50 AM

Excel Services Books

Today’s author: Eran Megiddo, the program manager who led the Excel Services 2007 effort. Eran is going to briefly talk about a few books that the Excel Services team wrote about the product. I wanted to let folks know about two new Excel Services books
Posted by David Gainer | 1 Comments
Tuesday, August 21, 2007 1:29 PM

Working With Excel's XML-Based File Formats

Some readers have expressed interest in working with and better understanding SpreadsheetML, part of the Open XML Formats recently standardized by Ecma International (I received a string of about a dozen emails in the last week or two asking how to do
Posted by David Gainer | 10 Comments
Filed under:
Tuesday, August 14, 2007 8:02 PM

Christian Stich on Excel Services: Financial option valuation implemented with Monte Carlo simulation using multithreaded User Defined Functions (UDFs)

Today’s author: Christian Stich, a program manager on the Excel Services team who likes to combine his finance and engineering backgrounds. Christian is going to talk about building a multithreaded UDF for Monte Carlo simulations and using it for options
Posted by David Gainer | 8 Comments
Tuesday, August 07, 2007 11:05 AM

Sam Radakovitz on Dynamic Ribbon Galleries

Today’s author: Sam Radakovitz, a program manager on the Excel team that enjoys creating VBA applications in Excel. When I went to create my first Excel 2007 Ribbon application, I found it a bit difficult to get the right RibbonX and VBA functions setup
Posted by David Gainer | 2 Comments
Filed under:
More Posts Next page »
 
Page view tracker