VBA automation of IE - submit text to site then copy image back to Excel

I know there are some threads for using Excel to load a webpage and submit username/pw information, but my needs are a little bit different.

I'm trying to take a character string from a cell, copy it into a free QR code generator (ex| http://goqr.me/ ), and bring the resulting image back into my spreadsheet. I like this generator because you don't need to click "submit" - it updates the image as the text is entered. Assuming/hoping that feature makes this easier.

Is this feasible? Trying to avoid the installation of new barcode fonts and the purchasing of barcode specific packages.

UPDATE:

Using the below code, I can get the browser to open and enter the desired text. I need a way to get the image back into my spreadsheet now. The code I'm using currently just returns "[object]" in C1.

Please Login or Register  to view this content.

Hello ALN1991,

Copy the code below into a new VBA module. The macro DownloadQRCode will need a few changes.

You will need to change the file name and location and the message you want to encode. These are in blue font.

Please Login or Register  to view this content.

Hello ALN1991,

VBA does not have any native functions to handle downloading pictures from the web to the worksheet. It can be done using more Windows API calls to copy the file to the clipboard and paste it to the worksheet.

I went with this method because it is a lot less code to deal with and if anything didn't work correctly it is easier to isolate the problem.