dcsimg
Results 1 to 3 of 3

Thread: [RESOLVED] Excel Help (Link Included)

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    May 2012
    Posts
    209

    Resolved [RESOLVED] Excel Help (Link Included)

    Dear Reader,

    I am attempting to use KevinInstructor's Basic Excel Tutorial the link is provided below:
    http://code.msdn.microsoft.com/Basic...Excel-4453945d

    According to the author, he has never received any problems and I am the first. I was wondering if there are any problems with my installation of Visual Studio 2010 Ultimate Edition. I receive 62 Errors, and 8 Warnings. The following are listed below:

    Code:
    Warning	1	Could not resolve this reference. Could not locate the assembly "Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors.	Basics_1
    
    Warning	2	The referenced component 'Microsoft.Office.Interop.Excel' could not be found. 	
    
    Warning	3	Namespace or type specified in the Imports 'Microsoft.Office.Interop.Excel' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\CreateFileCode.vb	4	9	Basics_1
    
    Warning	4	Namespace or type specified in the Imports 'Microsoft.Office' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\CreateFileCode.vb	5	9	Basics_1
    
    Error	5	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\CreateFileCode.vb	17	26	Basics_1
    
    Error	6	Type 'Excel.Workbooks' is not defined.	C:\Users\Nick\Documents\Software 
    Engineering\Examples\Basics_1\Excel_Modules\CreateFileCode.vb	18	32	Basics_1
    
    Error	7	Type 'Excel.Workbook' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\CreateFileCode.vb	19	31	Basics_1
    
    Error	8	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\CreateFileCode.vb	21	25	Basics_1
    
    Warning	9	Namespace or type specified in the Imports 'Microsoft.Office.Interop.Excel' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	4	9	Basics_1
    
    Warning	10	Namespace or type specified in the Imports 'Microsoft.Office' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	5	9	Basics_1
    
    Error	11	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	95	22	Basics_1
    
    Error	12	Type 'Excel.Workbooks' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	96	28	Basics_1
    
    Error	13	Type 'Excel.Workbook' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	97	27	Basics_1
    
    Error	14	Type 'Excel.Workbook' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	98	31	Basics_1
    
    Error	15	Type 'Excel.Names' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	99	24	Basics_1
    
    Error	16	Type 'Excel.Sheets' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	100	29	Basics_1
    
    Error	17	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	103	25	Basics_1
    
    Error	18	Type 'Excel.Name' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	112	31	Basics_1
    
    Error	19	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\ExcelInfo.vb	121	31	Basics_1
    
    Warning	20	Namespace or type specified in the Imports 'Microsoft.Office.Interop.Excel' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	4	9	Basics_1
    
    Warning	21	Namespace or type specified in the Imports 'Microsoft.Office' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	5	9	Basics_1
    
    Error	22	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	36	26	Basics_1
    
    Error	23	Type 'Excel.Workbooks' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	37	32	Basics_1
    
    Error	24	Type 'Excel.Workbook' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	38	31	Basics_1
    
    Error	25	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	39	32	Basics_1
    
    Error	26	Type 'Excel.Sheets' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	40	33	Basics_1
    
    Error	27	Type 'Excel.Range' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	41	28	Basics_1
    
    Error	28	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	43	25	Basics_1
    
    Error	29	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	53	54	Basics_1
    
    Error	30	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	99	26	Basics_1
    
    Error	31	Type 'Excel.Workbooks' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	100	32	Basics_1
    
    Error	32	Type 'Excel.Workbook' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	101	31	Basics_1
    
    Error	33	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	102	32	Basics_1
    
    Error	34	Type 'Excel.Sheets' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	103	33	Basics_1
    
    Error	35	Type 'Excel.Range' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	104	28	Basics_1
    
    Error	36	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	106	25	Basics_1
    
    Error	37	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	120	54	Basics_1
    
    Error	38	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	183	26	Basics_1
    
    Error	39	Type 'Excel.Workbooks' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	184	32	Basics_1
    
    Error	40	Type 'Excel.Workbook' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	185	31	Basics_1
    
    Error	41	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	186	32	Basics_1
    
    Error	42	Type 'Excel.Sheets' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	187	33	Basics_1
    
    Error	43	Type 'Excel.Range' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	188	28	Basics_1
    
    Error	44	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	190	25	Basics_1
    
    Error	45	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	199	59	Basics_1
    
    Error	46	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	237	26	Basics_1
    
    Error	47	Type 'Excel.Workbooks' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	238	32	Basics_1
    
    Error	48	Type 'Excel.Workbook' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	239	31	Basics_1
    
    Error	49	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	240	32	Basics_1
    
    Error	50	Type 'Excel.Sheets' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	241	33	Basics_1
    
    Error	51	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	243	25	Basics_1
    
    Error	52	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	253	54	Basics_1
    
    Error	53	Type 'Excel.Range' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	256	36	Basics_1
    
    Error	54	'Excel' is not declared. It may be inaccessible due to its protection level.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	259	53	Basics_1
    
    Error	55	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	304	22	Basics_1
    
    Error	56	Type 'Excel.Workbooks' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	305	28	Basics_1
    
    Error	57	Type 'Excel.Workbook' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	306	27	Basics_1
    
    Error	58	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	307	28	Basics_1
    
    Error	59	Type 'Excel.Sheets' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	308	29	Basics_1
    
    Error	60	Type 'Excel.Range' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	309	25	Basics_1
    
    Error	61	Type 'Excel.Interior' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	310	27	Basics_1
    
    Error	62	Type 'Excel.Range' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	311	26	Basics_1
    
    Error	63	Type 'Excel.Application' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	313	21	Basics_1
    
    Error	64	Type 'Excel.Worksheet' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	323	50	Basics_1
    
    Error	65	Option Strict On disallows late binding.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	387	13	Basics_1
    
    Error	66	Option Strict On disallows late binding.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	388	13	Basics_1
    
    Error	67	Option Strict On disallows late binding.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	389	13	Basics_1
    
    Error	68	'Excel' is not declared. It may be inaccessible due to its protection level.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	389	33	Basics_1
    
    Error	69	Option Strict On disallows late binding.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	390	13	Basics_1
    
    Error	70	Type 'Excel.Range' is not defined.	C:\Users\Nick\Documents\Software Engineering\Examples\Basics_1\Excel_Modules\OpenWorkSheets.vb	404	56	Basics_1
    I am currently spending my time trying to solve all the errors and warnings so any insight will help. Thank you for taking the time to read this message.
    If you find the information I give you useful, please rate my post and tell me why you thought it was helpful. Thanks!

    If your issue has been fixed, please come back to your thread and mark it Resolved. Thanks!

  2. #2
    Karen Payne MVP kareninstructor's Avatar
    Join Date
    Jun 2008
    Location
    Oregon
    Posts
    6,410

    Re: Excel Help (Link Included)

    Under project properties, Reference tab find 'Microsoft.Office.Interop.Excel' which should indicate the reference could not be found, remove it. Now add it back in by selecting Add button then select the reference on the .NET tab not the COM tab.

    On this project I reference Office.Interop.Excel version 11, you would select the version on your computer which is not 11.

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    May 2012
    Posts
    209

    Re: Excel Help (Link Included)

    Worked. Thank you. Resolved.
    If you find the information I give you useful, please rate my post and tell me why you thought it was helpful. Thanks!

    If your issue has been fixed, please come back to your thread and mark it Resolved. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width