Hey,

I need vba code to get "BIC" code from http://www.ibancalculator.com/iban_validieren.html
Let's say I check what's "BIC" code for IBAN PL13102039740000550201777929 and I have the result: BPKOPLPW
But now I would like to get take this data to excel to worksheet(Sheet1).Range("A1")

I have already macro which takes data (IBAN) from my excel and enter to IBAN browser and checks, but I don't know how to get result "BIC" code in my excel

Thank you in advance for help.