Link to home
Start Free TrialLog in
Avatar of TechGuise
TechGuiseFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of danishani
danishani
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TechGuise

ASKER

Perfect!  Works very nice, THANK YOU!
Glad to help! :)