VBA Code

Tobi101

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

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

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

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

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

http://shouldiuseaqrcode.com/