Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a Zip file from Excel
My program currently exports / saves an Excel sheet as a CSV file. However,
new program requirements call for my exporting the file as a ZIPPED CSV file. Our thoughts are to use a zip DLL component if one is available. This will be used by a large number of users and there is no setup routine involved. I've looked at Dynazip and Xceed. The former appears to require a 3rd party setup program and the latter requires .NET development. Are there any other options? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a Zip file from Excel
I use VBSecure from Moonlight Sofware. It is only $60 for a full redist
license. It also supports powerful file encryption independently of the zip/unzip function. www.moonlight-software.com . It works fine in VBA/VB6 as well as NET. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Perico" wrote in message ... My program currently exports / saves an Excel sheet as a CSV file. However, new program requirements call for my exporting the file as a ZIPPED CSV file. Our thoughts are to use a zip DLL component if one is available. This will be used by a large number of users and there is no setup routine involved. I've looked at Dynazip and Xceed. The former appears to require a 3rd party setup program and the latter requires .NET development. Are there any other options? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a Zip file from Excel
If your users will be using XP (and presumably Vista also works) then you
can use code found he http://www.rondebruin.nl/windowsxpzip.htm No components required. Tim "Perico" wrote in message ... My program currently exports / saves an Excel sheet as a CSV file. However, new program requirements call for my exporting the file as a ZIPPED CSV file. Our thoughts are to use a zip DLL component if one is available. This will be used by a large number of users and there is no setup routine involved. I've looked at Dynazip and Xceed. The former appears to require a 3rd party setup program and the latter requires .NET development. Are there any other options? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a Zip file from Excel
I'm evaluating this product but don't understand how to use it. I want to
save Excel sheets as csv files and compress them using vba code in Excel. The web site says there is an activeX file in the demo but I find no reference to any OCX file in the vbe references. The Readme file talks about some Chess game. The Help file is devoid of help. Any clue how to use this? I was hoping for a DLL or ocx to add to the project and some instruction on the properties & methods to use in the code underlying my gui. "Chip Pearson" wrote: I use VBSecure from Moonlight Sofware. It is only $60 for a full redist license. It also supports powerful file encryption independently of the zip/unzip function. www.moonlight-software.com . It works fine in VBA/VB6 as well as NET. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Perico" wrote in message ... My program currently exports / saves an Excel sheet as a CSV file. However, new program requirements call for my exporting the file as a ZIPPED CSV file. Our thoughts are to use a zip DLL component if one is available. This will be used by a large number of users and there is no setup routine involved. I've looked at Dynazip and Xceed. The former appears to require a 3rd party setup program and the latter requires .NET development. Are there any other options? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a Zip file from Excel
Disregard; i figured it out.
"Perico" wrote: I'm evaluating this product but don't understand how to use it. I want to save Excel sheets as csv files and compress them using vba code in Excel. The web site says there is an activeX file in the demo but I find no reference to any OCX file in the vbe references. The Readme file talks about some Chess game. The Help file is devoid of help. Any clue how to use this? I was hoping for a DLL or ocx to add to the project and some instruction on the properties & methods to use in the code underlying my gui. "Chip Pearson" wrote: I use VBSecure from Moonlight Sofware. It is only $60 for a full redist license. It also supports powerful file encryption independently of the zip/unzip function. www.moonlight-software.com . It works fine in VBA/VB6 as well as NET. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Perico" wrote in message ... My program currently exports / saves an Excel sheet as a CSV file. However, new program requirements call for my exporting the file as a ZIPPED CSV file. Our thoughts are to use a zip DLL component if one is available. This will be used by a large number of users and there is no setup routine involved. I've looked at Dynazip and Xceed. The former appears to require a 3rd party setup program and the latter requires .NET development. Are there any other options? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a Zip file from Excel
Appears to be a good choice from what I've seen in their download.
"Chip Pearson" wrote: I use VBSecure from Moonlight Sofware. It is only $60 for a full redist license. It also supports powerful file encryption independently of the zip/unzip function. www.moonlight-software.com . It works fine in VBA/VB6 as well as NET. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Perico" wrote in message ... My program currently exports / saves an Excel sheet as a CSV file. However, new program requirements call for my exporting the file as a ZIPPED CSV file. Our thoughts are to use a zip DLL component if one is available. This will be used by a large number of users and there is no setup routine involved. I've looked at Dynazip and Xceed. The former appears to require a 3rd party setup program and the latter requires .NET development. Are there any other options? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make a csv file open in excel instead of IE | Excel Discussion (Misc queries) | |||
Make sure that the excel file is still the same | Excel Programming | |||
How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file? | Excel Programming | |||
in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions | |||
Is there a way to make Excel file an executable? | Excel Programming |