Posts Tagged ‘Excel’
Creating an Office COM add-in: getting started for VB developers
Pieter van der Westhuizen | May 2nd, 2011
How to quickly create a shared COM add-in for Microsoft Outlook, Excel and word in VB.NET. Sample add-in is available for download.... Read the rest of this entry →
How to install multiple Office add-ins using one setup project
Pieter van der Westhuizen | March 30th, 2011
In today's post I'll demonstrate how you can install multiple Add-in Express Microsoft Office Add-ins without building multiple setup programs. Start by creating a new ADX COM Add-in project in Visual Studio
... Read the rest of this entry →
How to check programmatically if the user is editing an Excel cell
Andrei Smolin | March 23rd, 2011
Here's a typical scenario: your code modifying a workbook fails because the user types something into a cell. Now how to determine that Excel is in the edit mode?
... Read the rest of this entry →
Video: How Add-in Express makes Office development rewarding
Ty Anderson | March 10th, 2011
Office development is a rewarding experience providing you the developer using Visual Studio the opportunity to impact the lives of users of all shapes and sizes. Using Office as the development platform, you can build solutions that integrate with your users' business processes and simplify their life... Read the rest of this entry →
Video: How Microsoft Office abuses its developers and how Add-in Express stops this
Ty Anderson | March 10th, 2011
If you have any experience in developing solutions on the Office platform, you have most likely learnt that Office has the tendency to abuse its developers. One of the main reasons for this is that Office is comprised of several different applications like Outlook, Excel, PowerPoint and Word, and each of these applications has their own object model that you need to understand and master when building your solutions... Read the rest of this entry →
Video: Create an Office shared add-in – building advanced task panes and advanced Outlook regions, using advanced controls
Ty Anderson | February 7th, 2011
I admit it…it's been awhile since we published Part 1. So I don't blame you if gave up hope of ever seeing Part 2. But I'm here to tell you that you have not waited in vain because today we present to you Part 2 of the Create an Office Shared Add-in series... Read the rest of this entry →
Building a Real-Time Data server: Utility functions; building help, part 12
Maurice Calvert | January 27th, 2011
Hoping again for re-use, I created a little utility library which contains some general-purpose functions that you may find useful... Read the rest of this entry →
Building a Real Time Data server: Changing the Excel RTD Throttle Interval, part 11
Maurice Calvert | January 26th, 2011
By default, Excel won't call RefreshData more often than every 2 seconds (the Throttle Interval). For financial data that's arriving fast and furiously, this is reasonable, but for GeodesiX it makes the interface seem rather slow... Read the rest of this entry →
Building a Real Time Data server for Excel: Creating the Setup project, part 10
Maurice Calvert | January 25th, 2011
In part 2: Avoiding VSTO, I lauded Add-in Express for having such an easy interface to create a Steup Project. I stand by what I said, but GeodesiX goes a fair bit further than just implementing a few Excel UDFs. The problem that have to address is... Read the rest of this entry →
Building a Real Time Data server: Embedding a GoogleMap page in an Excel Task Pane, part 9
Maurice Calvert | January 24th, 2011
Another short subject, but worthy of a few remarks. The GoogleMaps taskpane is implemented in a separate project, hopefully re-usable. The task pane is created in Geodesix.AddinModule #27#, which also contains the event handlers
... Read the rest of this entry →
Building a Real Time Data for Excel: Avoiding Application Domain misery, part 8
Maurice Calvert | January 21st, 2011
This is a short but important subject (assuming you're using Addin Express for Office and .net). There are 3 types of Add-in Express module used in Geodesix
... Read the rest of this entry →
Building a Real Time Data server for Excel: Talking to the GoogleMaps APIs, part 7
Maurice Calvert | January 20th, 2011
This subject is already extremely well documented here, so I'll just point you to the relevant code. The call to GoogleMaps is at #7# in Geodesic.Resolve.Resolve... Read the rest of this entry →
Building an Excel Real Time Data server: Providing easy-to-read function names, part 6
Maurice Calvert | January 19th, 2011
Geeks like us have no qualms about typing =RTD("Geodesix.RTD",,"geocode","status","Tokyo") in an Excel cell to get a value. Normal people find this a bit clumsy, and it would be nice to humour them. Excel provides a way to this quite simply
... Read the rest of this entry →
Building a Real Time Data: Excel, multithreading and callbacks, part 5
Maurice Calvert | January 18th, 2011
Excel's muilti-threading is a strange beast. As we saw in part 4: Building a Real Time Data for Excel: Architecture, Excel calls happily but won't receive unsolicited calls. This is perfectly reasonable once you understand the Windows message pump, if the UI thread is waiting on a Dialog box, it can't accept other work... Read the rest of this entry →
Building a Real Time Data for Excel: Architecture, part 4
Maurice Calvert | January 17th, 2011
This is part 4 of the tutorial that describes the techniques necessary to build an Excel RTD server. If you have just come to this page, I suggest you read all parts in order, here is Building a Real Time Data for Excel, part 1. Putting together an RTD server is not particularly difficult… once you […]... Read the rest of this entry →
Building a Real Time Data for Excel: How RTD servers work, part 3
Maurice Calvert | January 14th, 2011
There are plenty of articles on Excel RTD programming, but I've yet to see one that correctly addresses the issues of multi-tasking. All the examples rely on a toy timer-driven application, which is not how real-world applications work
... Read the rest of this entry →