I am in need of assistance
I need a code that can zip a file up, but it must be for
WindowsXP not winzip.
Many thanks
John

Hi

It is not possible to run the XP zip with VBA

For Winzip see this page
http://www.rondebruin.nl/zip.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"JohnW" wrote in message ...
I am in need of assistance
I need a code that can zip a file up, but it must be for
WindowsXP not winzip.
Many thanks
John

not even as a shell ?

If this is for your home use (non commercial use) there is
Ultimatezip.com it provides all kinds of access.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ron de Bruin" wrote in message ...
Hi

It is not possible to run the XP zip with VBA

For Winzip see this page
http://www.rondebruin.nl/zip.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"JohnW" wrote in message ...
I am in need of assistance
I need a code that can zip a file up, but it must be for
WindowsXP not winzip.
Many thanks
John

Hi David

not even as a shell ?
To be honest I never spend much time to
look for a shell solution.

WinZip is 32 dollar I believe ( it is worth it)




--
Regards Ron de Bruin
http://www.rondebruin.nl


"David McRitchie" wrote in message ...
not even as a shell ?

If this is for your home use (non commercial use) there is
Ultimatezip.com it provides all kinds of access.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ron de Bruin" wrote in message ...
Hi

It is not possible to run the XP zip with VBA

For Winzip see this page
http://www.rondebruin.nl/zip.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"JohnW" wrote in message ...
I am in need of assistance
I need a code that can zip a file up, but it must be for
WindowsXP not winzip.
Many thanks
John

Many thanks to all
John
-----Original Message-----
Hi David

not even as a shell ?
To be honest I never spend much time to
look for a shell solution.

WinZip is 32 dollar I believe ( it is worth it)




--
Regards Ron de Bruin
http://www.rondebruin.nl


"David McRitchie" wrote in message
...
not even as a shell ?

If this is for your home use (non commercial use)
there is
Ultimatezip.com it provides all kinds of access.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site
changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm

"Ron de Bruin" wrote in
message ...
Hi

It is not possible to run the XP zip with VBA

For Winzip see this page
http://www.rondebruin.nl/zip.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"JohnW" wrote
in message ...
I am in need of assistance
I need a code that can zip a file up, but it must
be for
WindowsXP not winzip.
Many thanks
John






.

"Ron de Bruin" wrote...
not even as a shell ?
To be honest I never spend much time to look for a shell solution.

Tough your web site shows how to call winZip using a ShellAndWait call.

WinZip is 32 dollar I believe ( it is worth it)
...

Maybe, maybe not. The combination of tar and bzip2 command line utilities ported
from the Unix world generally produces smaller final archives than WinZip or
equivalents in less time. And both tar and bzip2 are open source and freely
available. But the OP wants Zip files, so gzip would be the freely available,
open source option.

Where's the value proposition for WinZip? If you believe Nico Mak just deserves
business, why? PkWare developed the original PkZip program. Why buy a clone of
the original? If faster & cheaper are legitimate reasons to buy something else,
why settle for WinZip when there are cheaper alternatives that provide
comparable performance? If A and B both perform the same operation in about the
same amount of time, but A costs $32 and B costs $0, which is truly 'worth it'?

Note that PowerArchiver and PkZip both support bzip2 compression. I can't find
any mention of bzip2 on WinZip's web site. bzip2 is the most compact format to
date, so a bit deficient not to support it.

By what objective measure would WinZip be preferred?

--
To top-post is human, to bottom-post and snip is sublime.

Hi Harlan

Tough your web site shows how to call winZip using a ShellAndWait call.
I mean for the WinXP Zip program

Where's the value proposition for WinZip
For me the only reason is that most people use WinZip
I am sure that there are better programs.



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Harlan Grove" wrote in message ...
"Ron de Bruin" wrote...
not even as a shell ?
To be honest I never spend much time to look for a shell solution.

Tough your web site shows how to call winZip using a ShellAndWait call.

WinZip is 32 dollar I believe ( it is worth it)
..

Maybe, maybe not. The combination of tar and bzip2 command line utilities ported
from the Unix world generally produces smaller final archives than WinZip or
equivalents in less time. And both tar and bzip2 are open source and freely
available. But the OP wants Zip files, so gzip would be the freely available,
open source option.

Where's the value proposition for WinZip? If you believe Nico Mak just deserves
business, why? PkWare developed the original PkZip program. Why buy a clone of
the original? If faster & cheaper are legitimate reasons to buy something else,
why settle for WinZip when there are cheaper alternatives that provide
comparable performance? If A and B both perform the same operation in about the
same amount of time, but A costs $32 and B costs $0, which is truly 'worth it'?

Note that PowerArchiver and PkZip both support bzip2 compression. I can't find
any mention of bzip2 on WinZip's web site. bzip2 is the most compact format to
date, so a bit deficient not to support it.

By what objective measure would WinZip be preferred?

--
To top-post is human, to bottom-post and snip is sublime.