<div>
Does this need to be done in VBA, would be a lot simpler in a DOS BAT script for example.<br />
<br />
<i><b>~bp</b></i>
</div>


Does this need to be done in VBA, would be a lot simpler in a DOS BAT script for example.

~bp

<div>
Bill,<br />
A BAT file would be fine...just trying to avoid a lot of manual work.<br />
<br />
Cook09
</div>


Bill,
A BAT file would be fine...just trying to avoid a lot of manual work.

Cook09

<div>
Bill,<br />
I had to disengage last night and at the moment am at work, I'll give it try afterwards....thanks<br />
<br />
Cook09
</div>


Bill,
I had to disengage last night and at the moment am at work, I'll give it try afterwards....thanks

Cook09

<div>
No worries, no rush from my side.<br />
<br />
<i><b>~bp</b></i>
</div>


<div>
Bill,<br />
Excellent...ran just like it was supposed to. &nbsp; Thanks for your help.<br />
<br />
Cook09
</div>


Bill,
Excellent...ran just like it was supposed to.   Thanks for your help.

Cook09

<div>
Ran right out of the box...first time...Thank You
</div>


Ran right out of the box...first time...Thank You

<div>
Welcome, glad that was useful, thanks for the feedback.<br />
<br />
<i><b>~bp</b></i>
</div>


Welcome, glad that was useful, thanks for the feedback.

~bp

<div>
<div class="content wysiwyg-content">
Is there a way, using VBA, to have the code go two levels deep within a subdirectory and move the .mp3 files to the root directory that contain all of the folders. &nbsp;There was a download from Kindle, which placed all the .mp3 songs within their respective folders (Artist, Album, songs). &nbsp;It's very time intensive to copy and paste to a portable device. &nbsp;How can this best be done with VBA?<br />
<br />
Cook09
</div>
</div>


Is there a way, using VBA, to have the code go two levels deep within a subdirectory and move the .mp3 files to the root directory that contain all of the folders.  There was a download from Kindle, which placed all the .mp3 songs within their respective folders (Artist, Album, songs).  It's very time intensive to copy and paste to a portable device.  How can this best be done with VBA?

Cook09

Excel: Move files in a folder

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

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 Disk Operating System (MS-DOS) was an operating system for x86-based personal computers, and traces of it are still found in the Windows operating system. DOS is still used in some embedded systems and for certain legacy 16-bit networks.

Microsoft DOS

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.