Founder/CEO

Biggles1

<div>
Thanks Bill, your solution worked (with some slight tweaking) on my part, but it worked!!<br />
<br />
QUESTION IS CLOSED
</div>


Thanks Bill, your solution worked (with some slight tweaking) on my part, but it worked!!

QUESTION IS CLOSED

<div>
Welcome, glad that helped.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


Welcome, glad that helped.



----------------------------------------

»bp

<div>
<div class="content wysiwyg-content">
<u>Command Line from VBA</u><br />
<br />
From VBA, I need to run Command Line (Shell) commands.<br />
<br />
For Example in Command Line I would type:<br />
<br />
&nbsp;<b><b>Del C:\......\Folder1\*.txt </b></b><br />
<br />
How would I do that from VBA? &nbsp;All the Shell etc... commands I try are not working.<br />
<br />
Help.<br />
<br />
Thanks
</div>
</div>


Command Line from VBA

From VBA, I need to run Command Line (Shell) commands.

For Example in Command Line I would type:

 Del C:\......\Folder1\*.txt 

How would I do that from VBA?  All the Shell etc... commands I try are not working.

Help.

Thanks

Command Line commands from Access VBA

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.