New to Excell in VB.. getting errors

  • Thread starter Thread starter Stephen Plotnick
  • Start date Start date
S

Stephen Plotnick

Public oexcel As Excel.Application
Public obook As Excel.Workbook
Public osheet As Excel.Worksheet

The Excel.???? variables get not defined errors. Is there something I need
to install on my VS 2005?

Thanks,
Steve
 
It look like I need the following:

Microsoft.Office.Interop.Excel.dll

It is not on my computer.

I own:

VS 2005 Pro
Office 2007 Pro

Should it be there???

Steve
 
http://carlosag.net/Tools/ExcelXmlWriter/Default.aspx


This library allows you to generate Excel Workbooks using
XML, it is built 100% in C# and does not requires Excel installed at all
to generate the files. It exposes a simple object model to generate the XML
Workbooks.<br>
It supports several features for generating Excel Workbooks
including:
<ul>
<li>Formatting</li>
<li>Alignment</li>
<li>Formulas</li>
<li>Pivot Tables</li>
<li>and more...</li>
</ul>
<br>
<b>Note:</b> This library is <b>free</b>, you can distribute
it and use it at your own will and risk, it is not supported by any company
including Microsoft or any other company, it does not belong to any company.
<br>
 
My original post was from some code I found so I could learn.

When I actually use the code and project file the error went away. What I
saw as an assembly.vb file in the one I was trying to learn from. I'm sure
this is a simple thing for experienced pogrammers but I would like to know
how to create a project from scratch and create this assembly.vb.

I did try and do an add resource for the interop.excel; that did not work.

Thanks for all the help.
Steve
 
Back
Top