473,766 Members | 2,023 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Code To Run WinZip?

Jim
I all, I have a database on a user's network drive with the following
path:

E:\NewDB\StatsD ata.mdb

I want to create a small "Utilities" database that the user can launch
which will run WinZip on the file StatsData.mdb and then eMail it to
me.

I can get WinZip to launch by using the Shell command as follows:

Dim RetVal
RetVal = Shell("C:\Progr am Files\WinZip\WI NZIP32.EXE", 1)

....but how do I then get it to zip the StatsData.mdb file and eMail it
to me? Anybody have an idea?

Nov 13 '05 #1
2 5694
I've got some code at my site for zipping/unzipping from Access. It's not
mine, but it is in the public domain and it's a start.
http://amazecreations.com/datafast/daaug.aspx

Look for a link to Zip - Unzip files
--

Danny J. Lesandrini
dl*********@hot mail.com
http://amazecreations.com/datafast/

"Jim" <jl*******@gmai l.com> wrote
I all, I have a database on a user's network drive with the following
path:

E:\NewDB\StatsD ata.mdb

I want to create a small "Utilities" database that the user can launch
which will run WinZip on the file StatsData.mdb and then eMail it to
me.

I can get WinZip to launch by using the Shell command as follows:

Dim RetVal
RetVal = Shell("C:\Progr am Files\WinZip\WI NZIP32.EXE", 1)

...but how do I then get it to zip the StatsData.mdb file and eMail it
to me? Anybody have an idea?

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2089
by: James Baker | last post by:
I'm using ASP and I need to generate a ZIP file that contains a list of files that I'm pulling from a database. I've determined WinZip's command line parameters so that I can use it, the problem is I'm unsure how to run WinZip on the server. Set WshShell = Server.CreateObject("WScript.Shell") WshShell.Run("c:\winzip.exe") Assuming this would work, how do I get the process to terminate upon
4
3297
by: EdB | last post by:
Has anyone ever interfaced with winZip from inside a VB.Net app? I'm looking to automatically zip up some files then delete them.
10
9295
by: Steve | last post by:
Is there anyone with experience using the Winzip command line add-in? I can't get it to create the zip file with a space in the file name. Using: RetValue = Shell("C:\winzip\wzzip.exe C:\MyFolder\My ZipFile.Zip C:\MyOtherFolder\MyFile.mdb") What is the syntax when you want a space in the zipfile file name?
3
4532
by: Jim | last post by:
I have a user who works remotely who just does not understand the concept of zipping and unzipping files no matter how many times I explain it. I need to create something for her that will do the following: * She receives an outlook message with a zipped file and opens the message. * She opens an Access "Utilities" database and clicks a button labeled "Unzip updated database from eMail message" * Somehow the code behind the button...
3
14150
by: Rob | last post by:
No way this should be that difficult... I have a program that does a file watch on a folder. When a file is created in this folder, I simply want to zip it up using WinZip (with the command line version of WinZip). I have been unable to do so with any success. I have been using DTE.ExecuteCommand to try and get this working but the error "Command "wzzip.exe" is not valid." keeps popping up.
15
11140
by: Karl | last post by:
Hi all, I regularly use FTP to place Self Extracting Zip files on the web for remote users to update their datafiles. Works very nicely. I have automated the creation of the initial zip file ( update.zip ), and can automate the FTP'ing of the SE zip file to the update site. I have, as yet, been unable to find a way of automating the creation of a SE zip file from the initial update.zip. I have performed a rather
10
3049
by: Elric02 | last post by:
I'm currently trying to get access to the Python source code, however whenever I try to extract the files using the latest version of WinZip (version 10) I get the following error "error reading header after processing 0 entries" I was under the impression that I could (from reading the various posts on this group) that I could simply extract the tar ball, using WinZip. If this is not the case does anybody know how I can actually get...
0
2738
by: yugho | last post by:
I'm sorry if I post Winzip question here, but I met a problem. I was running Winzip command by using process in VB.Net, but I had error that I don't know how to trace. 1. I create a batch file: "C:/zipbatch.bat" that contains below zip command winzip32.exe -min -a -ex "C:/zipfile.zip" "C:/sourcefile.csv" 2. I create new a process to run the zip command Dim t_process As New System.Diagnostics.Process t_process.StartInfo.FileName =...
0
9568
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9404
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10168
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10008
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9837
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8833
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7381
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6651
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
3532
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.