Input Data into Online Calculator

[rdelgadillo]

Hello,

First of all, thank you all so much for helping people like myself out. I am fairly new to VBA and am eager to learn (I'm currently reading Wiley's 2013 Power Programming book, great stuff). Please excuse me if what i post does not follow the forum rules. I'm not looking for a straight answer because i do actually want to understand, but please excuse my limited knowledge of VBA in your explanations.

I need to input data into an online calculator, then copy/paste the output into my workbook. I can navigate excel fairly well however i have almost no experience in manipulating IE.

Please Login or Register  to view this content.

The bottom three lines of code are the input, the button click and the output value.

Many Thanks!

[Leith Ross]

Hello rdelgadillo,

Welcome to the Forum!

You won't read about this in Wiley's books. This macro will get the check digit and place it in cell "A1" of the active sheet.

Please Login or Register  to view this content.

[scottiex]

In one of the other threads here (I forget the thread but I do have my own copy of the code with a simple addition) one of the guys here wrote the code to apply the algorithm calculate the check digits in the spreadsheet (for a wide range of standards).

Just mentioning in case it interests you.

[rdelgadillo]

My goodness this is incredible. Thank you so much. I have to say i wasn't expecting a full on working code (i thought people had to work for those sort of things), but this is really mind opening. I have much to learn, you mentioned that the Wiley book won't have much about data-scraping, don't worry too much but is there readily known catalogs that focus on data-scraping?

FYI, after slightly adding a few lines, i was able to generate 10000 codes. The company i work for will never have to worry about UPC codes for the next century. More then that, they are 100% accurate and free from any human error.

Here is the final code used that takes a highlighted row and outputs the digit into the "I" column.

Please Login or Register  to view this content.

Many Thanks!

[Leith Ross]

Hello rdelgadillo,

You're welcome. Glad I could help and to know you learned a lot.