<div>
is it possible for you to think of using a component like <a href="http://www.aspose.com/.net/excel-component.aspx" rel="ugc">http://www.aspose.com/.net/excel-component.aspx</a>&nbsp;?
</div>


is it possible for you to think of using a component like http://www.aspose.com/.net/excel-component.aspx [http://www.aspose.com/.net/excel-component.aspx] ?

<div>
I am also aware (but never used) of this free library: <a href="http://excelpackage.codeplex.com/" rel="ugc">http://excelpackage.codeplex.com/</a>
</div>


I am also aware (but never used) of this free library: http://excelpackage.codeplex.com/ [http://excelpackage.codeplex.com/]

<div>
Hi,<br />
<br />
Thanks for the comments. Regarding the last comment, how do you include the three files in the loop to create one excel file?<br />
<br />
Victor
</div>


Hi,

Thanks for the comments. Regarding the last comment, how do you include the three files in the loop to create one excel file?

Victor

<div>
You call that method with the result file name as the result parameter and the three files as the sources parameter:
<pre><code id="code-20-41256868-1">Merge(&quot;C:\MyPath\file4.xls&quot;, &quot;C:\MyPath\file1.xls&quot;, &quot;C:\MyPath\file2.xls&quot;, &quot;C:\MyPath\file3.xls&quot;)</code></pre>
</div>


You call that method with the result file name as the result parameter and the three files as the sources parameter:

Merge("C:\MyPath\file4.xls", "C:\MyPath\file1.xls", "C:\MyPath\file2.xls", "C:\MyPath\file3.xls")

<div>
Hi,<br />
<br />
What do I need to import in my project to use the code from the last post. The code I showing errors.<br />
<br />
Thanks,<br />
<br />
Victor
</div>


Hi,

What do I need to import in my project to use the code from the last post. The code I showing errors.

Thanks,

Victor

<div>
You need a reference to Microsoft.Office.Interop.E<wbr />xcel
</div>


You need a reference to Microsoft.Office.Interop.Excel

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
If I have the following three excel files: file1.xls, fil2.xls and file3.xls, how do I create file4.xls with three workbooks containing data<br />
from file1.xls, file2.xls and file3.xls?, how do I name the workbooks same names as the filenames?<br />
<br />
Thanks,<br />
<br />
Victor
</div>
</div>


Hi,

If I have the following three excel files: file1.xls, fil2.xls and file3.xls, how do I create file4.xls with three workbooks containing data
from file1.xls, file2.xls and file3.xls?, how do I name the workbooks same names as the filenames?

Thanks,

Victor

Help with creating one excel file with multiple workbooks from multiple excel files using VB.NET

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

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.