<div>
also note the difference in the code - using 'worksheet' instead of 'sheet'
</div>


also note the difference in the code - using 'worksheet' instead of 'sheet'

<div>
<div class="content wysiwyg-content">
I keep receiving the following error whenever I try to add a new Spread Sheet to an existing Excel File.<br />
Exception from HRESULT: 0x800A03EC.<br />
&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;at Excel.Sheets.Add(Object Before, Object After, Object Count, Object Type)<br />
&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at CamShaft.Form1.AddNewExcel<wbr />Sheet() in &lt;My Program Name&gt;<br />
Here is my code:<br />
<br />
Dim excelApp As Excel.Application<br />
Dim excelBook As Excel.Workbook<br />
Dim excelBook2 As Excel.Workbook<br />
Dim excelSheet As Excel.Worksheet<br />
<br />
excelApp = New Excel.Application<br />
If TempType.Text = &quot;T&quot; Then<br />
&nbsp; &nbsp;excelBook = excelApp.Workbooks.Open(Te<wbr />stFile.Tex<wbr />t)<br />
ElseIf TempType.Text = &quot;R&quot; Then<br />
&nbsp; &nbsp;excelBook = excelApp.Workbooks.Open(Re<wbr />alFile.Tex<wbr />t)<br />
End If<br />
excelSheet = excelBook.Sheets.Add<br />
excelSheet.PageSetup.Orien<wbr />tation = Excel.XlPageOrientation.xl<wbr />Landscape<br />
<br />
Any help would be appreciated.<br />

</div>
</div>


I keep receiving the following error whenever I try to add a new Spread Sheet to an existing Excel File.
Exception from HRESULT: 0x800A03EC.
   	at Excel.Sheets.Add(Object Before, Object After, Object Count, Object Type)
  	 at CamShaft.Form1.AddNewExcelSheet() in <My Program Name>
Here is my code:

Dim excelApp As Excel.Application
Dim excelBook As Excel.Workbook
Dim excelBook2 As Excel.Workbook
Dim excelSheet As Excel.Worksheet

excelApp = New Excel.Application
If TempType.Text = "T" Then
   excelBook = excelApp.Workbooks.Open(TestFile.Text)
ElseIf TempType.Text = "R" Then
   excelBook = excelApp.Workbooks.Open(RealFile.Text)
End If
excelSheet = excelBook.Sheets.Add
excelSheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape

Any help would be appreciated.


Problems adding new spreadsheet to an existing Excel file

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,