TechGuise
asked on
How to move multiple files to another folder in Access vba
Will the NAME method described by Jeffrey Coachman in the below question work somehow for with a wildcard?
https://www.experts-exchange.com/questions/23701586/Automatically-moving-file-after-importing-a-csv-file.html?anchorAnswerId=22384714#a22384714
This is what I'm trying
Name stExportPath & "*.csv" As stExportArchivePath & "*.csv"
I've used debug.print to look at the two paths and they seem correct (they include the last "\")
in the past I've used something close to the following, but I can't find it and can't get it to work either.
fso.MoveFile (stExportPath & "*.csv"), stExportArchivePath
Thanks
https://www.experts-exchange.com/questions/23701586/Automatically-moving-file-after-importing-a-csv-file.html?anchorAnswerId=22384714#a22384714
This is what I'm trying
Name stExportPath & "*.csv" As stExportArchivePath & "*.csv"
I've used debug.print to look at the two paths and they seem correct (they include the last "\")
in the past I've used something close to the following, but I can't find it and can't get it to work either.
fso.MoveFile (stExportPath & "*.csv"), stExportArchivePath
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help! :)
ASKER