
Tips.Net > WordTips Home > Macros > VBA Examples > Copying a File in VBA
Summary: If your VBA macro needs to make a copy of a file, here's how to do it. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)
Word uses a macro programming language known as Visual Basic for Applications, or VBA. Many of the tasks you can perform in regular Visual Basic you can also perform in VBA. One such task is to copy files. You can do so by using the FileCopy command, as follows:
FileCopy source, target
Of course, you need to provide the appropriate specifications for both the source and target designations. For instance, if you wanted to copy a file named MyFile.Doc from the current directory to the B: drive, you could do so
FileCopy myfile.doc, b:
If you try to copy a file that is currently open (either by Word or through a different program), VBA generates an error.
Tip #821 applies to Microsoft Word versions: 97 2000 2002 2003
Find and Replace Almost Anything! Learn the ins and outs of the powerful search engines available in Word. Learn to search for and replace text, formatting, graphics, and special characters the easy way with WordTips: Find and Replace.
It doesn't matter if you are a beginner or expert, the WordTips archives are the fastest way to improved productivity. (more information...)
Ask a Word Question
Make a Comment
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips