<div>
Glad to help. One warning: this will take the first csv workbook found, which could be an issue if you have more than one open. <br />
<br />
T
</div>


Glad to help. One warning: this will take the first csv workbook found, which could be an issue if you have more than one open.

T

<div>
Thats fine, will only ever have one.<br />
<br />
Cheers,<br />
Seamus
</div>


Thats fine, will only ever have one.

Cheers,
Seamus

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Im looking to copy over some data from one file to another, i cant use workbook.activate(&quot;XYZ.xls<wbr />&quot;) because the file name changes each day, i donr want to use activate next workbook as the user may have multiple workbooks open.<br />
<br />
Can i select the workbook to paste into based the on the fact it finishes .CSV as opposed to .xls<br />
<br />
So something like<br />
<br />
select.'code'<br />
Copy entire workbook<br />
Select &quot;xyz.xls&quot;<br />
Paste into sheet &quot;abc&quot;<br />
<br />
Select CSV file<br />
Close <br />
Dont save changes<br />
<br />
Thanks!<br />
Seamus
</div>
</div>


Hi,

Im looking to copy over some data from one file to another, i cant use workbook.activate("XYZ.xls") because the file name changes each day, i donr want to use activate next workbook as the user may have multiple workbooks open.

Can i select the workbook to paste into based the on the fact it finishes .CSV as opposed to .xls

So something like

select.'code'
Copy entire workbook
Select "xyz.xls"
Paste into sheet "abc"

Select CSV file
Close 
Dont save changes

Thanks!
Seamus

Select .CSV file

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