web scraping code

  1. M

    Split Copied Text Into Remaining Cells Once Cell Character Limit Has Been Reached or Maxed Out

    Hi Everyone: I am looking for a little bit of help. I have looked through the threads and dont see any thing that answers my question fully. Please see below code: Object: Once the character limit has been reached, paste remainder text in the cells below one another. Eg: I have copied text...
  2. M

    Scaping data from specific URL into Excel

    Good day All, I am new on this forum. I hope someone will be able to assist me. I have an excel document with a few Companies which I need to update pricing on products of a certain brand. To do this manually is a nightmare. Is there a way that I can put a URL for that certain brand in a cell...
  3. A

    Selecting a dynamic drop down list on a web page using VBA

    I am trying to automate data download from FFIEC website using VBA. I am not able to make a selection in the dropdown list "Reporting Period End Date or Year" on the webpage using the following code. The dropdown list gets updated based on selection you make on the ListBox1 above it. Would...
  4. P

    IE VBA Web Scrapping Table extract issue

    Hello Guys, i have below code that copy table on current webpage but when i change that page it not getting new table. note both the tables have same format, with little change in content, Dim i As SHDocVw.InternetExplorer Set i = New InternetExplorer Dim clipboard As MSForms.DataObject...
  5. P

    vba code to get element from label name

    Hi, I need to select option "Assigned to anyone" from below code. it looks like drop down list. HTML for it is as below <select class="form-control ng-pristine ng-untouched ng-valid ng-not-empty" ng-model="viewOptions.assignedToMe" ng-options="opt.value as opt.label for opt in...
  6. W

    Web Scraping code question, specific site

    I can't for the life of my re-code a custom project of ours to deal with changes on the following website. I'm not 100% sure what the developer was going after in the code below, but maybe the site changed?? I removed part of the code that used to attempt to scrape whether the number is a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top