Hello,
I want to get some additional information about car parts. Each part has similar structure webpage.
But first, I have to get past login screen, I have an account for http://catalogue.gordon-orders.lt/
What to start from?
Hello,
I want to get some additional information about car parts. Each part has similar structure webpage.
But first, I have to get past login screen, I have an account for http://catalogue.gordon-orders.lt/
What to start from?
I ran into a similar situation a while back. The only method I could find was to use the Send Key method. But, that method is extremely unstable and not a great method to use. Instead, I created a VB.Net application to do this for me. I created a program to login, scrape the HTML Source Code, dump it into a text document, which I then read into Excel.
The process went like this.
Run the program via Excel VBA. Wait for a file to dump. When file dumped, VBA read the file, grabbed information from it, closed out of program, deleted file, continued with macro.
If there is a way to do this inside of Excel I am all ears. That was just the method I used.
Hope it helps.![]()
Thank you for sharing your experience. I only have very basic programming experience, but know HTML a bit. Perhaps I should take online VBA beginner and further courses, before starting something to do. That website contains info about 150000 car parts. I'm also thinking, how much time it will take for macros, to visit each page and grab needed information like analog manufacture codes and pictures URL's and insert that to excel.
Ok. I found a way to past login screen using Internet Explorer.
But Internet Explorer is not supported or will not be soon, so now exprerimenting using Selenium webdriver and Edge.![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks