VSTO Installation and Excel 2003 and VS 2005

That’s what I thought also.

Thanks Ken.

I will let you know if I have any difficulties.

Martin Kulov
www.codeattest.com

That looks like the Excel globalization issue. See this article on MSDN for information:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2005_ta/html/OfficeVSTOGlobalization.asp

Harry Miller

This might be tricky. If the user opens VSTO-enabled document and the PIAs are not installed then the customization will just fail without calling any user-code.
Assuming you do have some other application that precedes VSTO document you need to take a look at Office 2003 PIAs redistributable.
http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en

Well, I am placing my excel workbook created with VSTO (VS2005 + Office ->Excel Workbook). Then, on compiling the the application, I place the excel application in network share. Now, if any user accesses the application from there, it prompts that PIAs are not installed. Is it possible that the PIA's get installed automatically without going through the proces of manually doing setup.

One option could be I place all the required PIAs in a MSI and execute the MSI first. But i want to avoid this option of running another file first.

I directly seek to run my excel application.

Please let me know ...

-thanks

You should be able to install Visual Studio 2005 onto the computer without needing to reinstall Excel 2003 or Visual Studio 2003.

If you are going to install Visual Studio 2005 and want to keep Visual Studio 2003 I would suggest doing a side-by-side install which should leave VS 2003 intact.

A couple of issues that you most likely will encounter regarding your VSTO projects that you created with Visual Studio 2003 after the install of Visual Studio 2005.

1. Once Visual Studio 2005 is installed Microsoft Office will load your VSTO 2003 projects using the .NET 2.0 Framework, so you may need to add security policies to the 2.0 Framework in order for the project to load.

2. Once Visual Studio 2005 is installed you may encounter problems debugging your VSTO 2003 project from within Visual Studio 2003. This is again a result of Microsoft Office loading the project in the 2.0 Framework. A couple of options that you have for debugging would be to convert the project to a VSTO 2005 project and you could then debug using Visual Studio 2005 or you could also implement an app config file to force Microsoft Office to load the project in the 1.1. Framework.

I hope this helps!

Regards,

Ken Laws
MSFT

This posting is provided "AS IS" with no warranties, and confers no rights.

For more information regarding Visual Studio Tools for Office 2005:

Best of Blogs: Visual Studio 2005 Tools for Office
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_2003_ta/html/odc_landvsto2005_ta.asp

Visual Studio Tools for Office Forum
http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=16

Visual Studio Tools for the Microsoft Office System
http://msdn.microsoft.com/office/understanding/vsto/default.aspx

Do you have any idea of when the Culture error will be fixed! I always need to run this code before I do anything in Excel.
int nID = app.LanguageSettings.get_LanguageID(Microsoft.Office.Core.MsoAppLanguageID.msoLanguageIDUI);
System.Threading.Thread t = System.Threading.Thread.CurrentThread;
System.Globalization.CultureInfo myCulture = t.CurrentCulture;
t.CurrentCulture = new System.Globalization.CultureInfo(nID);
regards,
gudmunh