GetVstoObject not working

[Ethan Strauss]

I am trying to customized Excel using VS.Net 2008 vsto using an Excel 2007
Template project type. I can accomplish most of what I need, but I can't add
a control dynamically to a newly created sheet.

I have followed http://msdn.microsoft.com/en-us/library/cc442981.aspx in
trying sheet.GetVstoObject() to get a Microsoft.Office.Tools.Excel.Worksheet
object to work with, but GetVstoObject always gives me
NullReferenceException. It appears that the VstoObject does not exist. I have
SP1 installed for VS2008.

Does anyone know how to get this to work?

Thanks!
Ethan

 

[TechGuy]

I have the same issue & also have the latest VS.Net 2008
(v9.0.21022.8) & VSTO with .NET framework 3.5 SP1.
GetVstoObject does not even show up in the Object viewer! I checked
the references & and even tried scanning various VSTO DLL's to no
help.

I hope someone from Microsoft is reading this.

Sam