vba courses london - Copy a number of .txt files into different locations automatical

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Copy a number of .txt files into different locations automatical

Michael has attended:
Excel VBA course

by - delegate Michael [1 post] (2007 Mar 8 Thu, 09:41) Reply

How do I run a command to copy a number of files to another folder on my hard drive

RE: copy a number of .txt files into different locations automat

by - trainer David gold contributer [428 posts] (2007 Mar 13 Tue, 11:24) Reply

Hi Michael

Sorry for the delay in getting back to you.
The code that you need to do this can be found by following the link below.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=827

Hope this helps
David

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?

Vba tip:

Display Text In a Msgbox On Multiple Lines

When displaying text in a MsgBox you may need to show it over multiple lines. To do this use:

vbCrLf

As in:

MsgBox "The System has detected an error." & vbCrLf & "Contact your System Administrator"

The first sentence in quotes will appear above the second in the MsgBox.

View all VBA hints and tips