<div>
Activeworkbook.worksheets(<wbr />&quot;Sheet1&quot;).<wbr />range(&quot;A1&quot;<wbr />).Value<br />
<br />
or<br />
<br />
workbooks(&quot;Example.xlsx&quot;).<wbr />Worksheets<wbr />(&quot;Sheet1&quot;)<wbr />.Range(&quot;A1<wbr />&quot;).Value
</div>


<div>
I get the error 'Activeworkbook' is not declared. It may be inaccessible due to its protection level
</div>


<div>
You may need to open the workbook first<br />
<br />
workbooks(&quot;yourworkbook.xl<wbr />sx&quot;).open<br />
Workbooks(&quot;yourworkbook.xl<wbr />sx&quot;).activ<wbr />iate<br />
<br />
Then I can't see how activeworkbook could give you any problems.
</div>


<div>
No that is not it.I thought that I had to use Microsoft.Office.Interop..<wbr />.. or Globals..... but can't work out the code
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
If I create a fresh Excel 2007 Add-In project in Visual Studio 2010 and create a Windows form,<br />
what is the simplest way to read cell values from the Active Excel workbook?<br />
Do I need to add any references or imports?
</div>
</div>


Hi

If I create a fresh Excel 2007 Add-In project in Visual Studio 2010 and create a Windows form,
what is the simplest way to read cell values from the Active Excel workbook?
Do I need to add any references or imports?

Activeworkbook.worksheets(&quot;Sheet1&quot;).range(&quot;A1&quot;).Value

or

workbooks(&quot;Example.xlsx&quot;).Worksheets(&quot;Sheet1&quot;).Range(&quot;A1&quot;).Value

I get the error &#39;Activeworkbook&#39; is not declared. It may be inaccessible due to its protection level

You may need to open the workbook first

workbooks(&quot;yourworkbook.xlsx&quot;).open
Workbooks(&quot;yourworkbook.xlsx&quot;).activiate

Then I can&#39;t see how activeworkbook could give you any problems.

No that is not it.I thought that I had to use Microsoft.Office.Interop.... or Globals..... but can&#39;t work out the code

VSTO Excel Add-In problem reading Excel cells

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.