Zip File

[DUF]

Hi,
I want to Zip a Access .mdb this is the code I came up with
Private Sub Command24_Click()
Call Shell("c:\program files\winzip\winzip32.exe" & "News.zip" & "NewsAgt.mdb&quot

End Sub
It's telling me that it can't fins the file

what is the correct way to code this????


regards

Duf

 

[scriverb]

Private Sub Command24_Click()
Call Shell("c:\program files\winzip\winzip32.exe" & " News.zip" & " NewsAgt.mdb&quot
End Sub

I just put in a few spaces as you Shell string was all cancatenated together without any spaces to designate the file names from each other or the path to winzip. Maybe this will help.


Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???