Developer

it_saige

Therapist

Dale James

Test your restores, not your backups...

Bill Prew

<div>
Thank you Alex and Subodh, exactly what I was looking for.<br><br>Both solutions work perfectly.<br><br>Many thanks.<br><br>Sincerely<br><br>Dale
</div>


Thank you Alex and Subodh, exactly what I was looking for.

Both solutions work perfectly.

Many thanks.

Sincerely

Dale

<div>
You're welcome Dale! Glad we could help.
</div>


<div>
<div class="content wysiwyg-content fr-view">
Hello Team<br><br>Can you please advise on the following?<br><br>Using VBA code, I wish to move an excel file from one folder to another if the file name contains "Mail Count Report" in the filename.<br><br>Source Folder: &nbsp;C:\Reports\<br>Destination Folder: &nbsp;C:\ Reports\Archive\<br><br>Thank you in advance.<br><br>Dale<br><br><br><br><br>
</div>
</div>



Hello Team
Can you please advise on the following?
Using VBA code, I wish to move an excel file from one folder to another if the file name contains "Mail Count Report" in the filename.
Source Folder:  C:\Reports\
Destination Folder:  C:\ Reports\Archive\
Thank you in advance.
Dale

Move file to another folder based on partial filename

Windows 10 is a personal computer operating system featuring the "universal application architecture" (UAP); apps can be designed to run across multiple devices with nearly identical code, including PCs, tablets, smartphones, embedded systems, Xbox One, Surface Hub and HoloLens. Windows 10 also includes a virtual desktop system, a window and desktop management feature called Task View, the Microsoft Edge web browser, support for fingerprint and face recognition login, voice-based search (Cortana), new security features for enterprise environments, and DirectX 12 and WDDM 2.0 to improve the operating system's graphics capabilities for games.

Windows 10

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.