<div>
Thanks Rossi,<br />
<br />
Last night I worked on the problem and solve it using VB6, but this macro is much easier and nice looking.<br />
<br />
The issue here is the HEADER col. in each excel file we are combining, the lazy users want to remove it automatically.<br />
<br />
Any help in this regard.<br />
<br />
Dear Moderator,<br />
I would like to separate the points between &quot;JRossi1&quot; and the original solver &quot;smozgur&quot;.<br />
<br />
JRossi, I hope you do not mind :)
</div>


Thanks Rossi,

Last night I worked on the problem and solve it using VB6, but this macro is much easier and nice looking.

The issue here is the HEADER col. in each excel file we are combining, the lazy users want to remove it automatically.

Any help in this regard.

Dear Moderator,
I would like to separate the points between "JRossi1" and the original solver "smozgur".

JRossi, I hope you do not mind :)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have several excel files named seq. 1,2,3..N; containing the same col names, I need to use a macro or VB appl. to open new execl and extract the data from sheet1 from each excel file and put it in sheet1 of the new excel file.<br />
<br />
I need to ask for the first &amp;&nbsp;last excel file name every time I want to do that.<br />
<br />
Thanks
</div>
</div>


Hi,

I have several excel files named seq. 1,2,3..N; containing the same col names, I need to use a macro or VB appl. to open new execl and extract the data from sheet1 from each excel file and put it in sheet1 of the new excel file.

I need to ask for the first & last excel file name every time I want to do that.

Thanks

VBA, Excel or VB (not .NET)

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.