Create a macro that will access a website and pull specific data

[Nilsjohanekman]

Hey community!

I have a complicated project and needed input/ information as to how to create a macro to solve this.

I need to create a macro that will access a website (with a username and password) and search for specific information.

I will have a list of PO's. I need to macro to input each one sequentially into the website and search its status. Then apart from retrieving that status, I need each PO assigned to a specific tab according to the status.

As the status' change from day to day, when the macro is run on a daily basis I would need it to pull the PO from one tab to the next (I believe it would search for the PO on the website as indicated above, pull the updated status and input into the correct tab and if the PO was already recorded in a previous stage (tab) then remove it from there, essentially 'moving' the PO from one stage to the next').

Any ideas? Input? Information? Code? Anything that can guide me in the right directions would be greatly apprecaited.

 

[Sektor]

First and foremost, it's good to know website URL with login and password. And also what info you need to fetch.

 

[Nilsjohanekman]

Dear Sektor,

Thank you for the quick reply! Unfortunately I do not have this information available right now. I wanted to create this prior to receiving this (I'm expecting this information something in the following 2 weeks).

Can you provide information assuming website = "MyPoWebsite", Login = "Nilsjohanekman" and password = "Password123"?

I believe that the fields on the website for logging in are named (I don't have a confirmation yet that that will actually be the website):

"User ID:"
"Password:"
and the submit button is named "Log In".

Thank you!!

Regards,
Nilsjohanekman

 

[Sektor]

In order to help you I need site URL with login and password. You can send private message when you get the real data.

 

[Nilsjohanekman]

Dear Sektor,

Got it! Thanks and will do!

Regards,
Nilsjohanekman

 

[Nilsjohanekman]

Hey Sketor,

One quick question! If I have an IE pop up appear after logging into a website that essentially has information/terms and asks to 'accept' or 'decline' would you know the code to bypass this (always choose 'accept')?

Regards,
Nilsjohanekman