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



Print Post      Close Window