Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate working days but change working week SamB Excel Discussion (Misc queries) 1 September 1st 08 09:17 PM
Making weekend days working days - the system cuts the working tim Fluffy Excel Discussion (Misc queries) 1 May 30th 08 10:02 PM
Newly created Get Function is not working when I copied the syntax from a working function CJ Excel Programming 1 January 16th 07 05:28 AM
Macro working in Excel 2003; not working in Excel 2000 Leslie Barberie Excel Programming 5 May 20th 04 07:51 PM
Adding sales from a non working day to the previous working day Alex Excel Programming 1 September 19th 03 08:48 AM


All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"