Jan F

I just need to clarify exactly what needs to be installed on the developer's computer vs. the user's computer in order to create or run specific VSTO 2005 + VSTO 2005 SE solutions.

Here's what I think the developer needs:
  • Document-level solutions require Office 2003 Professional (or better, or Word or Excel standalone products) on the developer machine.
  • Application-level solutions require one of the same Office 2003 SKUs as doc-level, or any edition of Office 2007. This is where I'm not sure. I think you need one of the Pro-or-better SKUs only because VSTO 2005 won't install with a lesser Office edition. Is that correct

This is what I think is needed for specific solutions to run on the user's computer (in addition to the other prereqs):

  • Doc-level solutions require either one of the Office 2003 Pro-or-better products or any edition of Office 2007.
  • App-level solutions for Office 2003 products will work with any edition of Office 2003 or Office 2007
  • App-level solutions for Office 2007 products will work with any edition of Office 2007
Can someone please either verify or correct me

Thanks,
--jan



Re: Visual Studio Tools for Office Development machine: Which Office editions?

Ji Zhou ¨C MSFT

Jan F wrote:

Doc-level solutions require either one of the Office 2003 Pro-or-better products or any edition of Office 2007.

Hi Jan,

Document level solutions are only available to Office2003. So whether in develop machine or target machine, it requirs Office 2003, not Office 2007. Also Document level solutions are supported in VSTO3(that is in Visual Studio 2008, still in beta2), and at that time we can have Office 2007 document level solutions.

I agree with your other perspectives.

To see more specific information, please refer this link:

http://msdn2.microsoft.com/en-us/library/aa942839(VS.80).aspx

Thanks

Ji






Re: Visual Studio Tools for Office Development machine: Which Office editions?

Jan F

According to this post, document-level solutions created for Office 2003 will run under Office 2007 Standard (or better). I've done minimal testing and found this to be true. Are you saying tha it works, but isn't officially supported by Microsoft, or that if I did more testing I'd hit problems with the solutions running at all

Thanks,
--jan




Re: Visual Studio Tools for Office Development machine: Which Office editions?

Ji Zhou ¨C MSFT

Hi Jan,

I want to clarify. I mean that document-level solutions developed by VSTO2005 are full supported by Office 2003. However, there are more or less some changes when we migrate from Office 2003 and Office 2007. So in most case, you can open a customization document (developed in Office 2003) with Office 2007. But, there are still some scenarios in which we will encounter error if do so. For example, you can have a test of the following codes: (These codes add a button into a cell. Success in both by VSTO&Office2003 and VSTO3&Office2007, but failed if use Excel2007 to open document developed by Excel2003)

Code Snippet

private void ThisWorkbook_Startup(object sender, System.EventArgs e)

{

Button btn = Globals.Sheet1.Controls.AddButton(this.Application.get_Range("A1", missing), "Test");

btn.Text = "Test";

btn.Click += new EventHandler(btn_Click);

}

void btn_Click(object sender, EventArgs e)

{

MessageBox.Show("Excel2");

}

Besides, you can see MSDN says: (in this link)

¡°If a user opens a Word 2003 or Excel 2003 customization on a computer that has Microsoft Office Word 2007 or Microsoft Office Excel 2007 installed, the customization will work in most cases. However, Excel 2003 customizations that have ListObject controls might not work as expected.

To make sure that existing Excel 2003 customizations continue to work on computers that have Excel 2007 installed, you must install the VSTO 2005 SE version of the Visual Studio Tools for Office runtime on the end user computer. This version enables Excel customizations that have ListObject controls to work as expected when the workbook is opened in Excel 2007.

Word 2003 and Excel 2003 customizations can be opened in Word 2007 and Excel 2007 only if the document format is not changed. If the user converts the document to one of the Microsoft Office Open XML Formats, the customization might not work as expected. ¡°

So, my opinion is that, according to Office version that end-users have, we can choose VSTO or VSTO3 to have a document-level development.

Wish this makes things clear J

Thanks

Ji






Re: Visual Studio Tools for Office Development machine: Which Office editions?

Jan F

Thanks Ji. That's just what I needed to know.
--jan