Printable View
Esteemed Forum Members and Lurkers:
Are there any primitive examples of opening and manipulating an Excel spreadsheet? I only have Excel 97 and VB.NET v2003.
I have waded through the VB help stuff (not very helpful) and MANY posts on this forum but haven't found what I am looking for. Several posts have code like:
Dim xl as New Excel.Application and EXL.Workbooks.Open(FN)
etc.
Excel and EXL are not recognized by my VB.Net.
Thank you for your gracious comments, suggestions, and assistance.
Many thanks to Vutle ... however ...
All went well until the very last step (one of the laws of the perversity of programming) generated an error ... adding the following:
Imports Microsoft.Office.Interop
does not recognize (sqiggly blue underline) "Microsoft.Office.Interop" and generates a build error:
"Namespace or type "Interop" for the Imports 'Microsoft.Office.Interop' can not be found"
The only other anomaly ... I got the Excel Object Library Reference added, however there were TWO libraries listed ...
Microsoft Excel 5.0 Object Library - XL5EN32.OLB
Microsoft Excel 8.0 Object Library - EXCEL8.OLB
Not knowing what to do here, I just selected Excel 8 and added it. Was that correct?
What do I need to do to get rid of the build error?
All comments, suggestions, and assistance is greatly appreciated.