Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need FileCopy with wildcards
- Thread starter Dylan
- Start date
SBendBuckeye
Programmer
If you set a reference to Microsoft Scripting Runtime, you can create a FileSystemOject that exposes drives, folders and files collections you can spin.
Sorry, all I have time to do is point you. If you need more help post again and we'll try to help.
Good Luck!
Have a great day!
j2consulting@yahoo.com
Sorry, all I have time to do is point you. If you need more help post again and we'll try to help.
Good Luck!
Have a great day!
j2consulting@yahoo.com
PJStephenson
Technical User
Try a Shell Command using something like xcopy
shell "xcopy C:\foldera\*.txt C:\folderb\ /h"
This is equivalent to the start menu/run command box. If you need more help on xcopy start a command prompt window and type xcopy /?
If you don't want to do this then try a loop on the DIR function (see the dir function example in access vba help) in foldera and use filecopy for anything that ends in .txt
hth
Peter
shell "xcopy C:\foldera\*.txt C:\folderb\ /h"
This is equivalent to the start menu/run command box. If you need more help on xcopy start a command prompt window and type xcopy /?
If you don't want to do this then try a loop on the DIR function (see the dir function example in access vba help) in foldera and use filecopy for anything that ends in .txt
hth
Peter
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question