ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   GetVstoObject not working (https://www.excelbanter.com/excel-programming/429531-getvstoobject-not-working.html)

Ethan Strauss

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

TechGuy

GetVstoObject not working
 
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


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com