View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ethan Strauss Ethan Strauss is offline
external usenet poster
 
Posts: 7
Default GetVstoObject not working

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