VBA Code

Tobi101 · 08-01-2014 05:27PM #1

Hi, I am trying to write VBA code to download a Zip file from a URL. This is part of a code to generate QR codes from a website which places them in a zip file. Each time the code is run the Zip file name changes so using Getelementbytag won't work. Any help will be appreciated.

TonyStark · 08-01-2014 05:29PM

Tobi101 wrote: »

Hi, I am trying to write VBA code to download a Zip file from a URL. This is part of a code to generate QR codes from a website which places them in a zip file. Each time the code is run the Zip file name changes so using Getelementbytag won't work. Any help will be appreciated.

Got some code specifically that is not working?

Tobi101 · 08-01-2014 05:35PM

No, I've tried looking for similar cases but can't seem to string it together and they all seem to be for a specific Zip file. So i am basically trying to look for help from scratch.

MacBoogerBalls · 09-01-2014 09:19AM

Basically you need to get file file name of the ZIP file to download.
Is the Web server public or private?

Can you enable directory browsing on the Web folder? or else host a text file with list of files and parse that?

Tobi101 · 09-01-2014 10:39AM

This is the website,

http://qrexplore.com/generate/

You should be able to generate a few QR codes for free under 100, and anything over 5 codes creates the ZIP if you want an example.

Creamy Goodness · 09-01-2014 10:49AM

http://shouldiuseaqrcode.com/

VBA Code

Comments