Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

VSTO: "Cannot access .xls" from Visual Studio/Excel Tools: Control missing

37 views
Skip to first unread message

PJV

unread,
Apr 20, 2009, 4:28:29 PM4/20/09
to
Hi,

My config is VSTO 2005 with Office 2003, using the document customization
version in Visual Studio 8.0. and .Net 2.0
I get two errors while using Excel from Visual Studio.
1. Get a Message box displaying "cannot access abc.xls" on trying to save the
Excel workbook within the Visual Studio after making changes
2. VS allows me to succesfully create a workbook template project and
programmatically add buttons or other tools in the excel worksheets. However
when I use the Excel toolbox for ListObjects/NamedRanges, it gives me the
below Doc cutomization error.


This document might not function as expected because the following control is
missing: list1. Data that relies on this control will not be automatically
displayed or updated, and other custom functionality will not be available.
Contact your administrator or the author of this document for further
assistance.


************** Exception Text **************
Microsoft.VisualStudio.Tools.Applications.Runtime.ControlNotFoundException:
This document might not function as expected because the following control is
missing: list1. Data that relies on this control will not be automatically
displayed or updated, and other custom functionality will not be available.
Contact your administrator or the author of this document for further
assistance. ---> System.Runtime.InteropServices.COMException (0x80020009):
Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION))
at Microsoft.VisualStudio.Tools.Applications.Runtime.IHostItemProvider.
GetHostObject(String primaryType, String primaryCookie, Object& hostObject)
at Microsoft.Office.Tools.Excel.ListObject.GetObjects()
--- End of inner exception stack trace ---
at Microsoft.Office.Tools.Excel.ListObject.GetObjects()

I have tried to look up on this but nothing useful so far.

Thanks,
PJV

Cindy M.

unread,
Apr 29, 2009, 5:33:54 AM4/29/09
to
Hi Pjv,

> My config is VSTO 2005 with Office 2003, using the document customization
> version in Visual Studio 8.0. and .Net 2.0
>

I'm a bit confused. You say VSTO 2005, but then Visual Studio 8.0. Which is
it?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

shdetect

unread,
Jun 19, 2009, 5:02:17 AM6/19/09
to
totally get the same exception as you posted.
hope this can help you: http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/81bd2438-ef51-4032-802e-13e9041b0e06

0 new messages