<div>
BobRosas,<br />
<br />
You're welcome !<br />
<br />
Regards,<br />
<br />
Patrick
</div>


BobRosas,

You're welcome !

Regards,

Patrick

<div>
<div class="content wysiwyg-content">
In VBA I get &quot;Bad file name or number.&quot; when I use <br />
FileCopy OldName, NewName <br />
where <br />
OldName = C:\Store\*.txt<br />
and <br />
NewName = E:\Store\<br />
Is * not allowed?<br />
How would I copy just the .txt files from one location to another.<br />
Thanks<br />

</div>
</div>


In VBA I get "Bad file name or number." when I use 
FileCopy OldName, NewName 
where 
OldName = C:\Store\*.txt
and 
NewName = E:\Store\
Is * not allowed?
How would I copy just the .txt files from one location to another.
Thanks


FileCopy with asterisk

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.