Re: Can I move files From Drive to drive using VBA
From: Dave Peterson (ec35720_at_netscapeXSPAM.com)
Date: 01/19/05
- Next message: Dave Peterson: "Re: How to test if an Excel spread*** exists in VBScript?"
- Previous message: Ola: "RE: Frank Kabel: A Sad Day for the Excel Community"
- In reply to: Jeff: "Can I move files From Drive to drive using VBA"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 Jan 2005 19:49:55 -0600
Take a look at Name in VBA's help.
Also FileCopy and Kill may be useful one day.
Jeff wrote:
>
> I would like to move and rename files automatically whenever someone finishes
> with the spread***. The idea is that they can only run it once and the data
> files are moved until the next month, and ready for the next department to
> use them.
-- Dave Peterson
- Next message: Dave Peterson: "Re: How to test if an Excel spread*** exists in VBScript?"
- Previous message: Ola: "RE: Frank Kabel: A Sad Day for the Excel Community"
- In reply to: Jeff: "Can I move files From Drive to drive using VBA"
- Messages sorted by: [ date ] [ thread ]