Macro with submit function included

Hi in below code for web fill and check IBAN. I cant find out of include the submit button. I can fill out the field but not submit. Please have a look and try below code and see if you can help. P. s What ever i try it always give me a object error. Please have a look at the home page
Use excel 2003

Thanks in advance Sincerely Abjac

Please Login or Register  to view this content.

P.s Cross post but no answers in the other forum.

http://www.mrexcel.com/forum/excel-q...-included.html

Please Login or Register  to view this content.

In this particular case, 'cause submit button has no ID …

Code to paste in a worksheet module :

Please Login or Register  to view this content.

Just compare with the inspector tool within your web browser …

Salud !

Originally Posted by abjac

Another thing is it possible to go through a range example from A1 to A10 and hold the result page lets say 4 seconds, and then close the page again. Then go and take A2 and repeat untill there is no more in column A to check?

It's look possible but should be better just to put in column B a result like "ok" or "Incorrect !" ?

Thats really great is there a way you can change the code. So it check in a range from example A1:A10 one by one.

so it open the validation, hold it 5 seconds and take the next one.

Is this possible?.

Thanks so far really great.

Sincerely

Abjac

Thanks Marc i understand and what you have done so far is a great help- I have one thing i have been strugled with. It is to close the explorer window. And i think i need that before i can make any loop. I have again read much about it and tried but get error what ever i try.
Can you put that into your code. So it close the window after example 5 seconds?

If you can do that i will try find out of make the loop through the cells.

Please have a look.

Sincerely

Abjac

HI Marc i have tried that with no luck, it gives me an error. Could you try put it in the code please.

Thanks

Abjac

What did you try ?

Where is your code ?

Hi on mobile now. I tried in the end to put. Ie.quit. But it gave me an object error. Sorry for the limited answer but out and send from mobile.
Sincerely Abjac

Originally Posted by Marc L

.Quit to close IE (you already had it in my CheckItems procedure !) …

So just see my CheckItems procedure …

Hi Marc. Back home again. I tried and landed on this code. It open now and wait and open the window and continue until no more IBANS in the cells, column A. Only problem left is that it take everytime the cell i double click on and run the check up for this IBAN, and the next time it just check the the same IBAN.

Here is the code so far. And i think maybe not so nice hehe but i try. The only thing left if to make it check one cell (IBAN)by a time instead of the same Iban.

Please see if you can correct it.

Here is my code now.

Sincerely Abjac

Please Login or Register  to view this content.

Just create a stand alone procedure, don't use this event !

Hi Marc. I tried with below code but it gives me and error have tried play around with it but still error. Please have a look at the code if time.

Thanks in advance Abjac

Please Login or Register  to view this content.

HI I finally landed at below code. I have not have succes making the loop, so i think i will make a new thread for this now.

Thanks Marc for you help. So much written about this but really many also have problems with it. So its really great. Thanks allot.

Will mark this as solved now.

Sincerely

Abjac

The code without loop as i have it now

Please Login or Register  to view this content.

HI Marc and thanks. I tried your code pasted allot of IBAN in from cell A2 and down. It seems your code stop work after cell A5 with out I know why. Would be good if it could run down to last used cell in column A.

You can try with these Ibans below and play with it-

Thanks in advance.


Sincerely

Abjac

Please Login or Register  to view this content.

I think ur right Marc. At work it stopped maybe because of the internet not fast i dont know- Bu now what i came home and tried it works like a charm . So its really a great code. Could be funny if it in some way could give the result in columb B. valid or not valid. hehe maybe you can do that, dont know if its possible. But its a great code Marc and thanks allot for you help.

Have a nice evening

Bonjour

Abjac

Hi Marc. WOW i am really impressed about this one. I cleaned internet explorer before and maybe that make it more smoth. But i run through all with not problems. I cant give you more reputation more, dont allow me and also cant rank it again, done allow me.

I will just say a big wow and a big thank you. Its so brilliant. A big WOW WOW for this one.

Thanks allot Marc

Have a nice evening
Bonjour from here in Madrid

Sincerely

Abjac

Bonjour Marc. Just a little thing
Its still a big wow I checked with 70 IBANS and sometimes it stop like its stock, i dont think its the code, its brilliant. But i found out if i refresh when it stop, it will start the same place. So if it was possible to make a refresh of the page if it wait more than lets say 1 min. This code is so good then. Could be funny and great if you could make that.Then it will always run all the way.
Sincerly
Abjac

Bonjour Marc
Thanks allot Marc ur code is working great, but it manage to block still. Its not ur code its brilliant. I found a way to avoid it. If i go tools, internet explorer. advanced and turn of show images. It runs perfect without any problem.
If that could be done with a macro turn of images and when done turn on again. It would make it run totally smoth. Hehe another work around.
But i dont know if this can be done with a macro.
If time have a look but thanks for the great code so far really wow.

Sincerely

Abjac

I don't think so …

Turn back on show image and turn on above it Use software rendering instead of GPU rendering and try …

HI Marc yes i guess its like that. Thanks allot for all your help it has been really impressing. So thanks allot.

Sincerely

Abjac

HI Ok i will for sure. FOr now it works like a charm with the images turned off. If i turn on, sometimes it still get stocked. But without it works really good. the Use software rendering instead of GPU rendering and try . I dont have in my home version of internet explorer. But i will try at work and see if that make any difference. I will for sure post here how it works.
Sincerely
Abjac

On my side, it's faster with this option active …
It takes between 150 & 180 seconds to scan the IBAN set of your post #21.

I try the other way - fastest - and only once I had a block
but just when I hit ESC key to abort VBA the procedure freed …
I never had such a issue but source is the server in my opinion.
I try around but seems difficult to have hand in when hangs the server …

Could you imagine the other way needs less than 7 seconds to do the same process ?!

I think your right Marc source is the server. I don't do it so fast as you for some reason. But it goes ok when I disable images. So for that its an ok way to do and don't take long time to change back,. You could try which I did. To copy the Ibans so you come up around 200. In this case I had the block, but only sometimes. But the solution to disable the images works fine, off course from a automatize perspective , it would be nice if this could be done by excel. But so important.
I will keep you posted if some new things come up or some new experience about this.

Thanks so much for your time, really great help.

Sincerely

Abjac

So forget IE way !

Fastest way tests with a bunch of 200 IBANs : less than 40 seconds !

Before to clean code, I let you choose between two displays :

1) See progress result cell by cell

2) Column B updates once at end of process, follow progress in status bar.

Which one ?

Bonjour Marc.
Wow if it can be done so fast it would really be great. If I can choose I would like to see progress result cell by cell. I am excited what you and how it can be done. But option 1 is perfect and if its so fast it will be so great.
So excited to see how that can be done

Thanks

Sincerely
Abjac

So clear all previous codes and enjoy this one ! (as usual, paste it in the IBAN worksheet module)

Please Login or Register  to view this content.

"Control IBAN …" still appears in the status bar during process …

No es una tontería si digo « Hoy la vida es chula para ti ! »

__________________________________________________________________________________
We are all very ignorant, what happens is that not all ignore the same things … (Albert Einstein)

Bonjour Marc

Just checked this code. Again wowowowowow. Its really great so fast and roll without any problems. I am so impressed. Your the best, if you ever come Madrid let me know and I will buy a beer for you here hehe,.

Its a fantastic code really.

Thanks allot Marc. I really appreciate it. WOW'
Have a nice evening

Sincerely

Abjac

Edit : wrong thread …

Hi. Marc. I added you as contact. Need a solution similar to upper one. And would be paid some for it. Please add me and i will send you a PM.
Sincerely
Abjac

Hi !

Better is creating a new thread as anyone with web skills can help you …

HI Marc i have done that. If time please have a look. I know your brilliant in this matter with web pages.
Thanks
https://www.excelforum.com/excel-pro...ml#post4883707

So just wait for someone who can play with this social network, I can't as it is very confidential …

See also on Web any tutorial to pilot IE in VBA.

Originally Posted by Marc L

So just wait for someone who can play with this social network, I can't as it is very confidential …

See also on Web any tutorial to pilot IE in VBA.

HI Marc. What if I make a other LinkedIn account. And pm you the password. Would you be willing to have a look and play with it? I know you are one of the best in this field. Sincerely Abjac send from mobile

Some here on this subject are better than I am, as I can't play with any social network …

Search on web tutorial for piloting IE browser and VBA samples, it's not very difficult.