vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

Home Contact Us
Order our Software

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile, shutdown database Read and Download

The Toolshed
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More

The Toolbox
Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..

Access >>> SQL
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

SharePoint
For our company file sharing and task management, we use
SharePointHosting

DryToast
Backup and query your BaseCamp® projects
Read More

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
vb123.com.au

Zip A File

Here I will show you a simple way to add a file to a zip file using Access VBA and WinZIp

Call ZipFile_FX("c:\a.zip", "c:\a.xls")

Private Sub ZipFile_FX(ZipFileName As String, fileToBeZipped As String)

Const ZIPEXELOCATION = "c:\program files\winzip\winzip32.exe"

Shell ZIPEXELOCATION & " -a " & Chr(34) & ZipFileName & Chr(34) & _
" " & Chr(34) & fileToBeZipped & Chr(34), vbNormalFocus

End Sub

Command line parameters for WinZip

Winzip is one of the most popular programs on the planet and if you want to automate it, they recommend upgrading to Winzip Pro and installing the free command line utility. If you want to try command line parameters without upgrading to Winzip pro, try the commands on this page using Windows Start then the Run text box. Read more here

Author Bio.

Garry Robinson has been involved in over a 100 Access projects, edits his companies web site at http://www.vb123.com/ and is a contributing editor to the Smart Access magazine. When Garry is not sitting at a keyboard, he can be found playing golf or swimming down at his local Sydney beach. Contact details … www.gr-fx.com

Other Pages at VB123.com That You May Want To Visit

Cleaning Up An Access Database

Converting Excel Spreadsheets To Microsoft Access

Outside Vb123.com

How to Zip using Windows Library
http://www.naterice.com/blog/template_permalink.asp?id=64

PolarZip is easy to write code for as long as you can handle DLL installs

Try this idea
http://www.members.shaw.ca/AlbertKallal/zip/index.htm

Click on the button for the next help page in this Access Loop.