Auto unzip file in VBA

I have a program that opens / closes 100s of files searching for key information. The problem is that they are 'gz' files zipped so i have to manually transfer all the files in my R: (zipped files) to my C: (unzipped), i would like someone to look at my VBA to see if there is a way to incorporate in a unzip function as it is opening a file.

Skills: Excel VBA

See more: combine sheets file vba, process data xml file vba, extarct data xml file vba, access vba unzip file, excel vba unzip all files in a folder, vba open zip file, vba unzip multiple files, vba read zip file contents, macro to unzip all files in a folder, vba code to extract zip file, vba unzip and rename file, excel, visual basic for apps, create file vba, access 2007 print file vba, vba access 2007 function, add line text file vba, body mail file vba, auto cad file, write ole object file vba

About the Employer:
( 2 reviews ) Gresham, United States

Project ID: #17592864

Awarded to:


Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$55 USD in 1 day
(4 Reviews)

13 freelancers are bidding on average $110 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

$150 USD in 2 days
(28 Reviews)

Ok. Let me do it for you. Thank you, Regards. ------------------------------------------------------------------------------------------ ----------------------------------------------- - -------------------------------

$50 USD in 0 days
(5 Reviews)

Hi let’s discuss in details over text. Thanks A

$50 USD in 3 days
(5 Reviews)
$120 USD in 3 days
(3 Reviews)

Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satis More

$250 USD in 3 days
(2 Reviews)

It's possible to add some code to unzip the files in case they are .gz, it will need to point to the unzip engine to trigger this action. Is it possible to have the VBA code where you want to add this option?

$90 USD in 1 day
(1 Review)

Hello dear contractor, I'm an excel expert with 10+ years of experience automating complex / repetitive tasks using Excel VBA as well as other technologies. I already have some code that unzip files, that we could More

$133 USD in 1 day
(1 Review)

I can incorporate in a unzip function. Please hire me. I have good vba experience. I can start work now. Regards.

$150 USD in 1 day
(0 Reviews)

"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimentation. I've a lot of experience in Complex typing that you may require. My work fulfills as well as keeps yo More

$100 USD in 5 days
(0 Reviews)

I can start working on it immediately, I have 9 years of industrial experience in VBA. Please ping me.

$111 USD in 3 days
(0 Reviews)

Hi There, My Name is Manu Lahariya. I have an MTech and BTech from IIT Kharagpur. I have developed 10+ Excel VBA based models for different clients during my tenure as an analytics associate. I have worked on mul More

$66 USD in 3 days
(0 Reviews)
$111 USD in 1 day
(0 Reviews)