Develop Excel add-in on machine without Office installed

V

VSTO

I am developing an Excel add-in for both 2003 and 2007. I have 2
separate VS solutions that contain a shared common project. I want to
be able to automate the building of the two solutions on a single
machine without having to install either versions of Office. Can this
be done?

I currently have Office 2003 on an XP machine and I am able to build
the '03 add-in without errors. When I try to build the '07 add-in I
get an assembly reference error. If I install the trial Office 2007
Enterprise Edition, then install the 2007 PIA's, I can reference the
correct COM reference (Microsoft Excel 12.0 Object Library) and build
without errors. When I uninstall Office 2007, but not the PIA's, the
reference breaks and it is no longer available to add through the
IDE. Can something be done about this? I have yet to uninstall
Office 2003, but if I do, will I come across the same issue?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top