[AccessD] Handle Zip and Cabinet folders (files)

Bill Benson bensonforums at gmail.com
Fri Nov 10 14:09:05 CST 2017


This list continues to astound me for the breadth and extra detail that
comes into discussions! Great posts here!

On Fri, Nov 10, 2017 at 8:52 AM, John Bodin <jbodin at sbor.com> wrote:

> Excellent!  I was surprised when I stepped through the debugger and didn't
> see the extensions.  Easy fix but not optimal if being used by many folks.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Gustav Brock
> Sent: Friday, November 10, 2017 8:42 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Handle Zip and Cabinet folders (files)
>
> Hi John
>
> That was a good question. Never thought of it, as I always turn that
> setting on. To be honest, I've never understood the purpose not to say the
> usefulness of turning off file extensions.
>
> But I did (turn extensions off) and ran a test. All files were still
> included.
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af
> John Bodin
> Sendt: 10. november 2017 13:17
> Til: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Emne: Re: [AccessD] Handle Zip and Cabinet folders (files)
>
> Gustav, I happened upon Ron DeBruin's zip code several weeks ago and
> utilized it in an app last week.  It worked well for me, but when I gave it
> to the user that really needed the feature, it failed.  Turned out that she
> needed to have "Hide extensions for known file types" unchecked in Folder
> Options on her Windows 7 machine (Windows Explorer/Organize/Folder and
> Search Options/View.)  When she didn't have that setting unchecked, if
> looking to extract all *.XLS files out of the zip, it would only see the
> file name w/o extension and skip over all XLS files.  I could single step
> through the code and see the file name did not contain the extension.
> Unchecking this then allowed the extension to be part of the file name.
>
> I only looked at your well documented code briefly, but do you know if
> this is something you have to worry about?
>
> Thanks,
>
> John
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Gustav Brock
> Sent: Friday, November 10, 2017 3:38 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Handle Zip and Cabinet folders (files)
>
> Hi Bill
>
> There are many variations on this - also here where Stuart once posted an
> example - and the core code is often the same with some variations.
>
> The functions you refer to seem to serve specific purposes, some with user
> interaction, while the goal for mine was to have a pair of very generic
> functions you can use everywhere and which will free you from the
> "plumbing" - checking/creating files and folders, good error handling, and
> returning meaningful result code.
> Also, the action of the functions is very similar to that of Windows
> Explorer when you operate it manually, for example by creating versioned
> zip folders (zipfolder.zip, zipfolder (2).zip, zipfolder (3).zip, etc.) if
> you chose not to overwrite an existing zip.
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af
> Bill Benson
> Sendt: 10. november 2017 02:08
> Til: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Emne: Re: [AccessD] Handle Zip and Cabinet folders (files)
>
> Ron DeBruin also has some pretty good code here <
> https://www.rondebruin.nl/win/s7/win001.htm> which was contributed to by
> Tom Ogilvy and KeepItCool, that I have used in many projects. I don't have
> time now to see whether your methods differs Gustav, but with Ron's so long
> published and so oft cited code available through numerous link-to's in
> many answer forums, something must have caused you to take this on as a
> test of your own coding prowess! So I hope to find something neat there
> when I have time to read it this weekend. There is one or two features of
> Ron's that relies on innate Excel functions but I think they can be
> replaced with other equivalents.
>
>
> On Wed, Nov 8, 2017 at 9:11 AM, Gustav Brock <gustav at cactus.dk> wrote:
>
> > Hi all
> >
> > Should you wish to zip/unzip or compress/decompress zip or cabinet
> > folders (files), I've put up functions for this at Experts Exchange:
> >
> >     Zip and unzip files and folders with VBA the Windows Explorer way
> >     https://www.experts-exchange.com/articles/31130/Zip-and-
> > unzip-files-and-folders-with-VBA-the-Windows-Explorer-way.html
> >
> >     Handle cabinet files and folders with VBA the Windows Explorer way
> >     https://www.experts-exchange.com/articles/31144/Handle-
> > cabinet-files-and-folders-with-VBA-the-Windows-Explorer-way.html
> >
> > Code is also at GitHub:
> > https://github.com/GustavBrock/VBA.Compress.git
> >
> > I used the old trick from Stuart to create a zip folder - thanks!
> >
> > /gustav
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list