I am converting my VB6 application to VB.net using Visual Studio 2013. The VB6 application is heavily dependent on data imported from and exported to Microsoft Excel files. My immediate issue is finding a successful method to transfer data from VB.net to Excel. I used a Microsoft article, http://support.microsoft.com/kb/301982
, “How to automate Microsoft Excel from Visual Basic .NET,” to develop an example application to transfer data to Excel.
The VB application develops 17 errors, many of which are duplicates. I infer from the errors that my required reference to the Microsoft Excel 15.0 Object Library has been unsuccessful. I also believe there are several unidentified procedures required to make this example work. I am a novice at using Visual Studio and VB.net so I really don’t have a clue of what to do next to get this example to work.
A sample of the errors follows:
'Imports' statements must precede any declarations.
'Excel.Application' is not defined.
'Excel.Workbook' is not defined.
'Excel.Range' is not defined.
'Excel' is not declared. It may be inaccessible due to its protection level.
'Excel.Chart' is not defined.
'Excel.Series' is not defined.
Please let me know the best way to proceed in this effort. I cannot see any evidence that the MS Excel Library is available to my application. Is there a way to assure it is available?