vba courses london - copy number txt files

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Copy a number of .txt files into different locations automatical

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

resolvedResolved · Low Priority · Version Standard

Michael has attended:
Excel VBA Intro Intermediate course

Copy a number of .txt files into different locations automatical

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

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

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

VBA tip:

Stop Screen Flickering When Running Code

Running VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place.

To switch off the screen until the program is run enter the following code line:

Application.ScreenUpdating = False

The screen comes on automatically on completion of the program.

View all VBA hints and tips


Server loaded in 0.07 secs.