|
Re: Computer programmers..can you help me?
Posted 2/6/2009 8:43:10 PM by luvsun27 Here is the syntax of the script. As I said...it has to be somehing specific to Vista because it works fine on XP and also a windows 2000 machine. Dim dtDateBegWeek, fname1 dtDateBegWeek = date-datepart("w",date-1) fname1 = "aROsaleslast.xls" & left(dtDateBegWeek,2) & mid(dtDateBegWeek,4,2) & right(dtDateBegWeek,2) Dim fso Set fso = CreateObject("Scripting.FileSystemObject") fso.MoveFile "aROsaleslast.xls", fname1 |