How to get Excel VBA to open a .gz file?

[Joey04]

I have a safe data source, where large files are always stored in a .gz

Is there a way to get excel VBA to open up the .gz file?

In the old old days, there used to be a windows command line that would extract files from a windows zip file, but I can't seem to find that anywhere. There has got to be an automated way to do this....

Thanks very much in advance.

Joey

[Leith Ross]

Hello joey04,

Windows has no native support for Gnu Zipped files. So, I have to ask if you have a program on your computer that will compress/decompress these files? If so you can use the VBA Shell command to start the program. If you know what the command line arguments are then you add that too.