copy several files of a folder for other, using VBA?

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
You have to copy them one-by-one. If you're wanting to copy all files
matching a particular pattern, use the Dir function to determine the files.
 
They are files *.XLS

Douglas J. Steele said:
You have to copy them one-by-one. If you're wanting to copy all files
matching a particular pattern, use the Dir function to determine the files.
Click to expand...
 
Dim strDestinationFolder As String
Dim strSourceFolder As String
Dim strFile As String

strDestinationFolder = "C:\Another Folder\"
strSourceFolder = "C:\My Data\"

strFile = Dir$(strSourceFolder & "*.XLS")
Do While Len(strFile) > 0
FileCopy strSourceFolder & strFile, strDestinationFolder & strFile
strFile = Dir$()
Loop
 
Thank you very much.


Douglas J. Steele said:
Dim strDestinationFolder As String
Dim strSourceFolder As String
Dim strFile As String

strDestinationFolder = "C:\Another Folder\"
strSourceFolder = "C:\My Data\"

strFile = Dir$(strSourceFolder & "*.XLS")
Do While Len(strFile) > 0
FileCopy strSourceFolder & strFile, strDestinationFolder & strFile
strFile = Dir$()
Loop
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba macro that allows insertion of symbols at cursor 0
Parse and rename multiple .pdf files 4
using excel vba ope a word doc and copy-paste into another word doc 0
Copy/Paste and remove blanks VBA 0
PowerPoint Printing PPT to PDF without losing quality 1
JPEG Images & Original Images In OneDrive Folders 3
vba powerpoint pasting named shape in selected named slides 0
Outlook Outlook 2010: Reminders in a calendar of a public folder 0

Back
Top