Random programming things I'd want to remember

Sunday, October 31, 2010

Programming for MS Office -- side note

So one interesting thing I discovered while programming for MS Office. If the user's version of the office suite does not match yours, make sure you download and reference the correct Office dll. The Office dll's are called IPA, that stands for the "Primary Interop Assembly." Office 2010 PIA is not out yet.

Let's say you are programming for Office 2007. Download (google and get from microsoft.com) and install the Office 2007 PIA. You have to have the Office suite installed on that computer as well. Once installed, go into the project references and find the proper dll, and use it in the project. The client will also have to have the PIAs installed to get your project to work.