GZ File open request in Excel

[Dojorgen]

I have a bunch of "*log.gz" files stored in my "R:" and would like to dump/convert into my "G:/INFO/Quality/Transfer" File so they open up in excel correctly

Request in VBA

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...zip-while-opening-connection.html#post5120037

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).