Script for file copy 1

[AlexIT]

I was trying to script a file save operation to create copies of a closed database on a periodic basis:

set tm=%tm::=-%
set dtt=%dt%%tm%
xcopy C:\folder\folder2\maindatabase.mdb z:\folder\folder\backup\"database-%dtt%-%tm%".bkp

I plan to schedule this for multiple backup copies.

What have I done wrong so far?

Thanks,
Alex

 

[ralphtrent]

try this:
t = DatePart("h", time) & DatePart("n", time) & DatePart("s", time)
d = DatePart("m", date) & DatePart("d", date) & DatePart("yyyy", date)

srcFile = "vpnPO.txt"
desFile = "vpnPO_"&t&"_"&d&".txt"
Dim oFSO, getFile
Set oFSO = CreateObject("Scripting.FileSystemObject&quot
oFSO.CopyFile "c:\temp\"&srcFile,"c:\temp\"&desFile, True
Set oFSO = Nothing

 

[AlexIT]

That does it! I was trying a couple differnt ways but THAT worked...thanks.

Alex