paul.hartland at fsmail.net
paul.hartland at fsmail.net
Tue Apr 20 08:48:39 CDT 2004
To all,
Thanks for all your help with my last WinZip question, however now I need to know where I am going wrong. I have the following code in my application:
Dim strShiftData As String
Dim strDownTime As String
Dim wzFinal As String
Dim wzFiles
strShiftData = "C:\Shifts_" & Replace(DATE, "/", "") & "_" & Replace(Time(), ":", "") & ".txt"
strDownTime = "C:\Down_" & Replace(DATE, "/", "") & "_" & Replace(Time(), ":", "") & ".txt"
DoCmd.TransferText acExportDelim, , "qryNewExportShiftDataToText", strShiftData, True
DoCmd.TransferText acExportDelim, , "qryNewExportDownTimeToText", strDownTime, True
wzFinal = "C:\Branston" & Replace(DATE, "/", "") & Replace(Time(), ":", "")
wzFiles = Shell("C:\Program Files\Winzip\Wzzip.exe " & wzFinal & " " & strShiftData & " " & strDownTime, 0)
MsgBox Finshed Export,,**** User Message Export Complete ****
However I cant seem to see any zip file on my C: drive, and I get no error message. Can someone please see where I am going wrong here. I have WinZip 9.0 and the Command Line Interface installed.
Thanks in advance for all your help.
Paul Hartland
Database Designer/Developer.
Join the UK's number one for the internet
www.freeserve.com/time