Macros outside of Excel?

Asked

Viewed 63 times

1

I’m venturing through the world of programming, and at first, I’m using a lot of VBA in the company, and it’s helping me a lot, tasks that took hours, I’m doing in a few seconds using macros!

I work very often looking for data on a site, on this site there are several Id’s of certain products, depending on the category are more than 500, and I need to search the id of each of them, these id’s only appear when I click on the product, 1 by 1 I got all the data at once, accessing the html code and filtering, because all the codes, in html, start with "id=***". I only studied in excel and all beauty.

It would be possible to create a macro that "automates" the search process?

because it’s very repetitive and it’s always the same step, with some selections.

Thank you!

  • It depends on the HTML code of the site... Often some event needs to be triggered, see this answer, that triggers the onchange event.

  • Yes, it is possible to create macros to do this kind of process. html object within the interface of VBA. After that is similar to the case of looking in a spreadsheet.

  • Thank you very much, I am looking for the solutions in which I was indicated.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.