jnelson

Hello All!

I am new to this group, and to VBA. I am working with a terminal emulation software and need to "modernize" some routines that we use.

We currently have a process in place where a user runs the program and downloads data to a floppy drive in a compressed (using PKZip for DoS) format. We are having problems running this under W2K and I would like to redo the compression method using VBA.

I have downloaded some freeware compression DLLs for VB and was wondering how to use this in VBA.

Has anyone worked with calling external file compression programs from VBA?

TIA
Brad

Wamphyri

What DLLs are you using? Most likely you are going to have to reference them. Tools -> References then choose the DLLs to reference.

Flyguy

Have a look here:
http://www.relevant.nl/vb/compress.html

jnelson

Thanks for the replies.

It appears that both of these can work fine with VB, but can these be called from VBA?

My limitation is that all of the code needs to be in VBA.

Thanks,
Brad

Flyguy

I see no reason why the code couldn't be used from within VBA