Showing posts from 2014

Excel Add in Compile Errors and Upgrade Problems/Issues

Six years ago an Excel add in was developed using VSTO 3.0 and excel 2007, thank you Microsoft for giving out such a stable platform for developing solutions for Microsoft Office applications.

Add in worked well with Excel 2007 and 2010, Excel 2013 started giving problems as Microsoft decided not to support MDI in 2013, so we had to compile and make few changes to make it work well with the new SDI of Excel 2013. But the code in version control system is from 6 years and wont compile, so we had to create a new project in Visual Studio 2012 and VSTO 4.0 and add all the files to that. New project is compile and was able to get a working add in.

Old add in was published to a shared location(in production) and the update interval is set for a week. We wanted to push the new add in and overwrite the existing one but as the old one has a published location that is in production we could take the risk of publishing the new one to the old published location and test it out there to see if it …