<div>
<div class="content wysiwyg-content">
I need to copy all the data from a sheet in a closed workbook into a sheet in my open workbook. <br />
Can someone point me in the direction of how to set this up in VBA code? I need to copy sheet1 from my file called &quot;IVAL&quot; &nbsp;and paste values into my open file on the sheet called &quot;IVAL&quot;.
</div>
</div>


I need to copy all the data from a sheet in a closed workbook into a sheet in my open workbook. 
Can someone point me in the direction of how to set this up in VBA code? I need to copy sheet1 from my file called "IVAL"  and paste values into my open file on the sheet called "IVAL".

Copy Data from another workbook via VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.