<div>
Not really part of your question but you may find formatting the date as yyyymmdd will help you when it comes to sorting the list of files alphabeticallu, they will appear in date order.
</div>


Not really part of your question but you may find formatting the date as yyyymmdd will help you when it comes to sorting the list of files alphabeticallu, they will appear in date order.

<div>
Vippx, <br />
<br />
Thx for ur code, you are realy good :)
</div>


Vippx,

Thx for ur code, you are realy good :)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'd like to copy an existing (*'xls) file from a folder [C:\nbutane\rsview\report\<wbr />] into the same folder but the new file will be rename.<br />
<br />
FileCopy &quot;C:\nbutane\rsview\report\<wbr />FC Daily Report.xls&quot;, &quot;C:\nbutane\rsview\report\<wbr />FC Daily Report\&quot; &amp;&nbsp;Format(Date - 1, &quot;ddmmmmyyyy&quot;) &amp;&nbsp;&quot;.xls&quot;<br />
End Sub<br />
<br />
Source (original filename) : FC Daily Report.xls<br />
Target (new filename) : FC Daily Report.xls 07112004.xls<br />
<br />
Anyone can verify if the VB code above is correct? Thx.<br />
&nbsp; &nbsp;
</div>
</div>


Hi,

I'd like to copy an existing (*'xls) file from a folder [C:\nbutane\rsview\report\] into the same folder but the new file will be rename.

FileCopy "C:\nbutane\rsview\report\FC Daily Report.xls", "C:\nbutane\rsview\report\FC Daily Report\" & Format(Date - 1, "ddmmmmyyyy") & ".xls"
End Sub

Source (original filename) : FC Daily Report.xls
Target (new filename) : FC Daily Report.xls 07112004.xls

Anyone can verify if the VB code above is correct? Thx.
   

Copy file and rename it using VB

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.

Programming

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.