Renaming Files in Drive when Email arrives

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I want to rename a file that is in my disk drive. Currently this is what
happens... every day I get a file copied to a shared folder in my drive, then
I get an email saying it was copied. I have to rename it to a specific name
because I have an application in access that is linked to it.
I want to be able to rename the file when I get the email, the problem is
that the excel file comes in with a name that is a number that has no
relation to the one from the day before...
how can I change the file name? the folder only contains that file.

Thanks!!
 
Am Wed, 10 Aug 2005 09:28:05 -0700 schrieb mecg96:

Hi,

you can use the FileSystemObject from the Microsoft Scripting Runtime by
adding a reference to that library via Tools/References.
 
Back
Top