ilrosebud26
asked on
How do I archive files in an excel script?
I have to write a macro that will be attached to a command button. The mscro needs to move all files beginning with COSTB and STATUSB to a different folder. They all have an .xls extension. I need to move then from c:\my\documents to c:\my documents\backup. I know this is simple for a person that writes macros all of the time....but I am just beginning.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help. This worked great on my local drive.
ASKER
Rosemary