>Hello,
>
>I'm using Visual Foxpro 6.0 and have the following problem:
>
>I've made an Excelfile from a table and want to copy it to a diskette.
>So far I know what to do but the problem is that the Excel file is 1.8 MB big. That doesn't fit on a 1.44 MB diskette.
>So I want to compress it in a 'universal'-format (like pkzip) so it will fit on a diskette. Actually I prefer to have a self-extracting executable of the Excelfile.
>
>How can I elegantly 'zip' my Excelfile, and make a self-extracting file, in VFP 6.0 while I don't bother the user with ugly screens or interruption?
>
There are several solutions - you can use on of the third-party add-ons like DynaZip that can be used within VFP, or you can run an external program to do with command line parameters.
You can run an external program without it appearing in another Window using the Windows API or an OLE automation server that can control the appearance of programs that it starts. There is a sample class that uses the CreateProcess() API call to launch and wait on the external program to terminate in the FAQ here on UT that I wrote; look under the Class or Win32API topics..