<div>
Hi,<br />
Let me first thank you for your quick response. &nbsp;Everything works great except for the paste part. &nbsp;The workbooks are created but they are empty. &nbsp;Any ideas?
</div>


Hi,
Let me first thank you for your quick response.  Everything works great except for the paste part.  The workbooks are created but they are empty.  Any ideas?

<div>
Hi,<br />
<br />
Works fine here...<br />
You have to run this macro while your source document is open.<br />
<br />
Run this macro step by step (F8 = next step), so you can see what he copies.<br />
<br />
Greetz<br />
Wim
</div>


Hi,

Works fine here...
You have to run this macro while your source document is open.

Run this macro step by step (F8 = next step), so you can see what he copies.

Greetz
Wim

<div>
Hi,<br />
My source document is open however I am performing this on an beforeclose event of the source workbook. &nbsp;Would that matter? &nbsp;<br />
<br />
When I debug through it and hit enter to paste (manually) when it gets to that point in the code it works.<br />
<br />
I appreciate all of the help.<br />
<br />
Thanks.
</div>


Hi,
My source document is open however I am performing this on an beforeclose event of the source workbook.  Would that matter?  

When I debug through it and hit enter to paste (manually) when it gets to that point in the code it works.

I appreciate all of the help.

Thanks.

<div>
<div class="content wysiwyg-content">
Hi I am a new user of VBA and I need some assistance. &nbsp;I would like to copy 100 (1-100) rows from an excel spreadsheet to a new workbook. &nbsp;Then copy the next 100 rows (101-200), etc. &nbsp;If I have 300 rows I would like to open 3 new 100 row workbooks. <br />
<br />
I am assuming that this is not that difficult to do.<br />
<br />
Thanks.
</div>
</div>


Hi I am a new user of VBA and I need some assistance.  I would like to copy 100 (1-100) rows from an excel spreadsheet to a new workbook.  Then copy the next 100 rows (101-200), etc.  If I have 300 rows I would like to open 3 new 100 row workbooks. 

I am assuming that this is not that difficult to do.

Thanks.

Copy a specific number of rows until the end of a spreadsheet

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.