Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Zip then emai 4 files please
HI I use Winzip 11.2.
I wish to zip 4 files monthly (there are other files in the folder). How do I add (via loops) more than one zipped file? I was going to use the .SendMail SendTo to email the zipped file. Thanks Simon I was using ub ZipFile() Dim ZipPath As String Dim ZipIt As String Dim Source As String Dim Dest As String ZipPath = "C:\Program files\Winzip\" Source = "N:\mis\location\location Reporting\082008\UKA Reports\CARC- GE3" Dest = "C:\tt.zip" 'Note spaces important ZipIt = Shell(ZipPath & "Winzip32 -a " & Dest & " " & Source, vbNormalFocus) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Zip then emai 4 files please
'
' Macro1 Macro ' Macro written 15/09/2008 by axuklslav ' Sub ZipFile() Dim ZipPath As String Dim ZipIt As String Dim Source As String Dim Dest As String ZipPath = "C:\Program files\Winzip\" Source = "N:\mis\oth\othReporting\082008\UKA Report\" 'Source2 = "N:\mis\oth\othReporting\082008\UKA Reports\CARC-lt3" 'Source3 = "N:\mis\oth\othReporting\082008\UKA Reports\UKA-GE3" 'Source4 = "N:\mis\oth\othReporting\082008\UKA Reports\UKA-lt3" Dest = "N:\mis\oth\othReporting\082008\UKA Reports" 'Note spaces important ZipIt = Shell(ZipPath & "Winzip32 -a " & Dest & " " & Source & Source2 & SourceŁ & Source4, vbNormalFocus) ZipIt = Shell(ZipPath & "Winzip32 -a " & Dest & " " & Source, vbNormalFocus) ZipIt.SendMail ", Subject:="RBS2-5 zipped files, ReturnReceipt:=True" Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Zip then emai 4 files please
See
http://www.rondebruin.nl/zip.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Simon" wrote in message ... HI I use Winzip 11.2. I wish to zip 4 files monthly (there are other files in the folder). How do I add (via loops) more than one zipped file? I was going to use the .SendMail SendTo to email the zipped file. Thanks Simon I was using ub ZipFile() Dim ZipPath As String Dim ZipIt As String Dim Source As String Dim Dest As String ZipPath = "C:\Program files\Winzip\" Source = "N:\mis\location\location Reporting\082008\UKA Reports\CARC- GE3" Dest = "C:\tt.zip" 'Note spaces important ZipIt = Shell(ZipPath & "Winzip32 -a " & Dest & " " & Source, vbNormalFocus) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
Sending only part of a workbook thru emai | Excel Worksheet Functions | |||
how to default WritePassword under excel workbook property for any files as long as those files are the offsprings of the parent file | Excel Programming | |||
Extracting out of a emai address string | Excel Discussion (Misc queries) | |||
Macro to open *.dat files and save as .txt (comma delimited text files) | Excel Programming |