| Author |
Message |
|
Z
#1 / 23
|
 Compressing a file from within VBS I want to compress a file and send it to an email recipient from within Excel. Is this possible? If not then I want to compress a file and send it to an email recipient from Desktop. Any help would be much appreciated. Z-TIA
OS - XP/PRO
Email - OE6
---
Outgoing mail is certified Squeeky clean.
Checked by AVG anti-virus system ( http://www.*-*-*.com/ ).
Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
|
| Sat, 18 Sep 2004 13:14:08 GMT |
|
 |
|
Atrax
#2 / 23
|
Compressing a file from within VBS you can use a zip component, PKZip command line, Perl's Archive::Tar module (via WSC/Perlscript) or a number of other techiques. two of the above are touched on at http://www.infinitemonkeys.ws/ (one
in ASP, one in Perl-Win32)
Atrax - MVP [Microsoft Most Valued Professional]
http://www.infinitemonkeys.ws/
Host with me for $100 a year!
http://www.atrax.ws/hosting/
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
|
| Sat, 18 Sep 2004 13:26:26 GMT |
|
|
|
Dr.X
#3 / 23
|
Compressing a file from within VBS Check out zipgenius. my favorite. nicer than winzip and no nag screens. free. www.zipgenius.it
--
Dr.X
Quote: > you can use a zip component, PKZip command line, Perl's Archive::Tar > module (via WSC/Perlscript) or a number of other techiques. > two of the above are touched on at http://www.infinitemonkeys.ws/ (one
> in ASP, one in Perl-Win32)
> Atrax - MVP [Microsoft Most Valued Professional]
> http://www.infinitemonkeys.ws/
> Host with me for $100 a year!
> http://www.atrax.ws/hosting/
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
|
| Sat, 18 Sep 2004 13:34:35 GMT |
|
|
|
Z
#4 / 23
|
Compressing a file from within VBS XP has it's own file compression. At the moment I save the excel file then compress it then email it to the recipient. I'm trying to automate this as I do this quite often so I'm trying to write a script (emphasis on trying lol). Quote: >I want to compress a file and send it to an email recipient from within
>Is this possible?
>If not then I want to compress a file and send it to an email recipient
from
>Desktop.
Z-TA
Quote: > Check out zipgenius. my favorite. nicer than winzip and no nag screens. > free. > www.zipgenius.it
> --
> Dr.X
> > you can use a zip component, PKZip command line, Perl's Archive::Tar
> > module (via WSC/Perlscript) or a number of other techiques.
> > two of the above are touched on at http://www.infinitemonkeys.ws/ (one
> > in ASP, one in Perl-Win32)
> > Atrax - MVP [Microsoft Most Valued Professional]
> > http://www.infinitemonkeys.ws/
> > Host with me for $100 a year!
> > http://www.atrax.ws/hosting/
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
--- Outgoing mail is certified Squeeky clean. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
|
| Sat, 18 Sep 2004 13:45:17 GMT |
|
|
|
Dr.X
#5 / 23
|
Compressing a file from within VBS in that case, I'm sure there is a zipdll file somewhere in the system directory or somewhere on that drive. but you will have to establish some kind of communication with it. make calls and stuff (I don't have its phone number ;-). once you know how to do that, it would be a simple matter of scripting the
compression and email routine in a vbs or js. I think you will still have
to save the document first then click a shortcut on your quick launch that
leads to your script. unless you can make dll calls in VBA from excel.
--
Dr.X
Quote:
> XP has it's own file compression. > At the moment I save the excel file then compress it then email it to the > recipient. > I'm trying to automate this as I do this quite often so I'm trying to write > a script (emphasis on trying lol). > >I want to compress a file and send it to an email recipient from within
> >Is this possible?
> >If not then I want to compress a file and send it to an email recipient
> from
> >Desktop.
> Z-TA
> > Check out zipgenius. my favorite. nicer than winzip and no nag screens.
> > free.
> > www.zipgenius.it
> > --
> > Dr.X
> > > you can use a zip component, PKZip command line, Perl's Archive::Tar
> > > module (via WSC/Perlscript) or a number of other techiques.
> > > two of the above are touched on at http://www.infinitemonkeys.ws/
(one
> > > in ASP, one in Perl-Win32)
> > > Atrax - MVP [Microsoft Most Valued Professional]
> > > http://www.infinitemonkeys.ws/
> > > Host with me for $100 a year!
> > > http://www.atrax.ws/hosting/
> > > *** Sent via Developersdex http://www.developersdex.com ***
> > > Don't just participate in USENET...get rewarded for it!
> ---
> Outgoing mail is certified Squeeky clean.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
|
| Sat, 18 Sep 2004 14:07:55 GMT |
|
|
|
Z
#6 / 23
|
Compressing a file from within VBS Yes, I've found the zipfldr.dll now I'm looking for it's phone number <bg>. Z-TA
Quote: > in that case, I'm sure there is a zipdll file somewhere in the system > directory or somewhere on that drive. but you will have to establish some > kind of communication with it. make calls and stuff (I don't have its phone > number ;-). > once you know how to do that, it would be a simple matter of scripting the
> compression and email routine in a vbs or js. I think you will still have
> to save the document first then click a shortcut on your quick launch that
> leads to your script. unless you can make dll calls in vba from excel.
> --
> Dr.X
> > XP has it's own file compression.
> > At the moment I save the excel file then compress it then email it to
the
> > recipient.
> > I'm trying to automate this as I do this quite often so I'm trying to
> write
> > a script (emphasis on trying lol).
> > >I want to compress a file and send it to an email recipient from within
> > >Is this possible?
> > >If not then I want to compress a file and send it to an email recipient
> > from
> > >Desktop.
> > Z-TA
> > > Check out zipgenius. my favorite. nicer than winzip and no nag
screens.
> > > free.
> > > www.zipgenius.it
> > > --
> > > Dr.X
> > > > you can use a zip component, PKZip command line, Perl's Archive::Tar
> > > > module (via WSC/Perlscript) or a number of other techiques.
> > > > two of the above are touched on at http://www.infinitemonkeys.ws/
> (one
> > > > in ASP, one in Perl-Win32)
> > > > Atrax - MVP [Microsoft Most Valued Professional]
> > > > http://www.infinitemonkeys.ws/
> > > > Host with me for $100 a year!
> > > > http://www.atrax.ws/hosting/
> > > > *** Sent via Developersdex http://www.developersdex.com ***
> > > > Don't just participate in USENET...get rewarded for it!
> > ---
> > Outgoing mail is certified Squeeky clean.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
--- Outgoing mail is certified Squeeky clean. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
|
| Sat, 18 Sep 2004 14:15:22 GMT |
|
|
|
Dr.X
#7 / 23
|
Compressing a file from within VBS sorry i don't have it's number but i'll bet some in this group or the wsh group does. maybe ms website has it. not sure. i seem to remember a hacker had a program that accessed it and used it in the win98 version. it came with Plus98 and Plus95. the hack was able to make calls to the zip & unzip dll so it *must* be possible. but i never tried to reverse engeneer his work. --
Dr.X
Quote:
> Yes, I've found the zipfldr.dll now I'm looking for it's phone number <bg>. > Z-TA
> > in that case, I'm sure there is a zipdll file somewhere in the system
> > directory or somewhere on that drive. but you will have to establish
some
> > kind of communication with it. make calls and stuff (I don't have its
> phone
> > number ;-).
> > once you know how to do that, it would be a simple matter of scripting
the
> > compression and email routine in a vbs or js. I think you will still
have
> > to save the document first then click a shortcut on your quick launch
that
> > leads to your script. unless you can make dll calls in vba from excel.
> > --
> > Dr.X
> > > XP has it's own file compression.
> > > At the moment I save the excel file then compress it then email it to
> the
> > > recipient.
> > > I'm trying to automate this as I do this quite often so I'm trying to
> > write
> > > a script (emphasis on trying lol).
> > > >I want to compress a file and send it to an email recipient from
within
> > > >Is this possible?
> > > >If not then I want to compress a file and send it to an email
recipient
> > > from
> > > >Desktop.
> > > Z-TA
> > > > Check out zipgenius. my favorite. nicer than winzip and no nag
> screens.
> > > > free.
> > > > www.zipgenius.it
> > > > --
> > > > Dr.X
> > > > > you can use a zip component, PKZip command line, Perl's
Archive::Tar
> > > > > module (via WSC/Perlscript) or a number of other techiques.
> > > > > two of the above are touched on at http://www.infinitemonkeys.ws/
> > (one
> > > > > in ASP, one in Perl-Win32)
> > > > > Atrax - MVP [Microsoft Most Valued Professional]
> > > > > http://www.infinitemonkeys.ws/
> > > > > Host with me for $100 a year!
> > > > > http://www.atrax.ws/hosting/
> > > > > *** Sent via Developersdex http://www.developersdex.com ***
> > > > > Don't just participate in USENET...get rewarded for it!
> > > ---
> > > Outgoing mail is certified Squeeky clean.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
> ---
> Outgoing mail is certified Squeeky clean.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
|
| Sat, 18 Sep 2004 14:22:43 GMT |
|
|
|
Alex K. Angelopoulo
#8 / 23
|
Compressing a file from within VBS I took a look with a type library browser on my XP system and can't find the DLL or OCX that does this. It might not be exposed to scripting for some reason. Quote:
> sorry i don't have it's number but i'll bet some in this group or the wsh > group does. maybe ms website has it. not sure. i seem to remember a hacker > had a program that accessed it and used it in the win98 version. it came > with Plus98 and Plus95. the hack was able to make calls to the zip & unzip > dll so it *must* be possible. but i never tried to reverse engeneer his > work. > --
> Dr.X
> > Yes, I've found the zipfldr.dll now I'm looking for it's phone number
> <bg>.
> > Z-TA
> > > in that case, I'm sure there is a zipdll file somewhere in the system
> > > directory or somewhere on that drive. but you will have to establish
> some
> > > kind of communication with it. make calls and stuff (I don't have its
> > phone
> > > number ;-).
> > > once you know how to do that, it would be a simple matter of scripting
> the
> > > compression and email routine in a vbs or js. I think you will still
> have
> > > to save the document first then click a shortcut on your quick launch
> that
> > > leads to your script. unless you can make dll calls in vba from excel.
> > > --
> > > Dr.X
> > > > XP has it's own file compression.
> > > > At the moment I save the excel file then compress it then email it to
> > the
> > > > recipient.
> > > > I'm trying to automate this as I do this quite often so I'm trying to
> > > write
> > > > a script (emphasis on trying lol).
> > > > >I want to compress a file and send it to an email recipient from
> within
> > > > >Is this possible?
> > > > >If not then I want to compress a file and send it to an email
> recipient
> > > > from
> > > > >Desktop.
> > > > Z-TA
> > > > > Check out zipgenius. my favorite. nicer than winzip and no nag
> > screens.
> > > > > free.
> > > > > www.zipgenius.it
> > > > > --
> > > > > Dr.X
> > > > > > you can use a zip component, PKZip command line, Perl's
> Archive::Tar
> > > > > > module (via WSC/Perlscript) or a number of other techiques.
> > > > > > two of the above are touched on at http://www.infinitemonkeys.ws/
> > > (one
> > > > > > in ASP, one in Perl-Win32)
> > > > > > Atrax - MVP [Microsoft Most Valued Professional]
> > > > > > http://www.infinitemonkeys.ws/
> > > > > > Host with me for $100 a year!
> > > > > > http://www.atrax.ws/hosting/
> > > > > > *** Sent via Developersdex http://www.developersdex.com ***
> > > > > > Don't just participate in USENET...get rewarded for it!
> > > > ---
> > > > Outgoing mail is certified Squeeky clean.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
> > ---
> > Outgoing mail is certified Squeeky clean.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
|
| Sat, 18 Sep 2004 14:59:34 GMT |
|
|
|
Torgeir Bakke
#9 / 23
|
Compressing a file from within VBS Quote:
> Yes, I've found the zipfldr.dll now I'm looking for it's phone number <bg>.
Dr.X, Alex and I have had this discussion before. Unless you want to resort to API to create CAB files, you can e.g. use the Makecab.exe from the Microsoft Cabinet SDK or EclipseCabinet99 (free 3.rd party component). More info in this thread:
Subject: Compression
Newsgroups: microsoft.public.scripting.VBScript
Date: 2002-01-25 10:18:20 PST
You can use http://groups.google.com/advanced_group_search to fetch it :-)
--
torgeir
|
| Sat, 18 Sep 2004 20:35:02 GMT |
|
|
|
Z
#10 / 23
|
Compressing a file from within VBS How can I alter the script in Eclipse to suit Makecab.exe? Z-TIA
"There is light at the end of the tunnel".
Quote:
> > Yes, I've found the zipfldr.dll now I'm looking for it's phone number
<bg>.
> Dr.X, Alex and I have had this discussion before. Unless you want to
resort to
> API to create CAB files, you can e.g. use the Makecab.exe from the
Microsoft
> Cabinet SDK or EclipseCabinet99 (free 3.rd party component).
> More info in this thread:
> Subject: Compression
> Newsgroups: microsoft.public.scripting.vbscript
> Date: 2002-01-25 10:18:20 PST
> You can use http://groups.google.com/advanced_group_search to fetch it :-)
> --
> torgeir
--- Outgoing mail is certified Squeeky clean. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.343 / Virus Database: 190 - Release Date: 22/03/2002
|
| Sun, 19 Sep 2004 16:40:44 GMT |
|
|
|
Torgeir Bakke
#11 / 23
|
Compressing a file from within VBS Quote:
> How can I alter the script in Eclipse to suit Makecab.exe?
I gave you some wrong input I think. It looks like Makecab.exe only can compress one single file. Cabarc.exe is the one to be used to create . Run cabarc.exe without any parameters to get online help. --
torgeir
|
| Sun, 19 Sep 2004 20:19:46 GMT |
|
|
|
Z
#12 / 23
|
Compressing a file from within VBS I don't have Cabarc.exe on my XPPRO system? Z
Quote:
> > How can I alter the script in Eclipse to suit Makecab.exe?
> I gave you some wrong input I think. It looks like Makecab.exe only can
compress
> one single file. Cabarc.exe is the one to be used to create . Run
cabarc.exe
> without any parameters to get online help.
> --
> torgeir
--- Outgoing mail is certified Squeeky clean. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.344 / Virus Database: 191 - Release Date: 2/04/2002
|
| Mon, 20 Sep 2004 10:27:04 GMT |
|
|
|
Torgeir Bakke
#13 / 23
|
Compressing a file from within VBS Quote:
> I don't have Cabarc.exe on my XPPRO system?
No, you needto download the Microsoft Cabinet SDK: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnca...
--
torgeir
|
| Mon, 20 Sep 2004 10:44:42 GMT |
|
|
|
Z
#14 / 23
|
Compressing a file from within VBS Actually I only need to compress one file anyway so I think that Makecab.exe will do the job. Now how do I write this into a script? After it's compressed I need it to send to a mail recipient. My scripting prowess is lacking........ The test line I have for makecab.exe is: Makecab.exe /L C:\Test C:\Test\tester.xls test.cab Z-TIA
Quote:
> > I don't have Cabarc.exe on my XPPRO system?
> No, you needto download the Microsoft Cabinet SDK:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnca... ml/cabdl.asp Quote: --- Outgoing mail is certified Squeeky clean. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.344 / Virus Database: 191 - Release Date: 2/04/2002
|
| Mon, 20 Sep 2004 11:04:48 GMT |
|
|
|
Z
#15 / 23
|
Compressing a file from within VBS Oh I have this so far: Set ws = CreateObject("WScript.Shell")
ws.Run "Makecab.exe /L C:\Test C:\Test\tester.xls test.cab"
Z-TA
Quote:
> Actually I only need to compress one file anyway so I think that Makecab.exe > will do the job. > Now how do I write this into a script? > After it's compressed I need it to send to a mail recipient. > My scripting prowess is lacking........ > The test line I have for makecab.exe is: > Makecab.exe /L C:\Test C:\Test\tester.xls test.cab > Z-TIA
> > > I don't have Cabarc.exe on my XPPRO system?
> > No, you needto download the Microsoft Cabinet SDK:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnca... Quote: > ml/cabdl.asp > > --
> > torgeir
> ---
> Outgoing mail is certified Squeeky clean.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.344 / Virus Database: 191 - Release Date: 2/04/2002
--- Outgoing mail is certified Squeeky clean. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.344 / Virus Database: 191 - Release Date: 2/04/2002
|
| Mon, 20 Sep 2004 11:09:48 GMT |
|
| |
