scrap data

  1. J

    web scraping of exchange rates

    hello gurus, Please advise if there is a way to scrap the exchange rate displayed from this website: https://centralbank.ae/en/forex-eibor/exchange-rates/ what i'm trying to do here is to collect the current displayed rates and paste it on my workbook as a table like it is. and refreshes if...
  2. M

    Scrape Values from PDFs - VBA or Power Query or Something Else

    Hello- I have a folder with 25 different PDFs that have values of different investments. The PDFs can be grouped into 4 different layouts, meaning 10 are organized the same way but with information specific to that PDF, 9 others organized the same way but with info specific to that PDF, and so...
  3. A

    How to scrape data from PDF to Excel using VBA?

    Private Sub CommandButton1_Click() Dim pdfFile As Variant Dim selPDF As Variant pdfFile = Application.GetSaveAsFilename(InitialFileName:=ThisWorkbook.ActiveSheet.name, FileFilter:="PDF Files (*.pdf), *.pdf") pdfPath.Value = pdfFile pdfPath.Locked = True End Sub Well, this...
  4. M

    Search through files in folder and return rows containing specific text and also workbook name

    Hi All, I have a folder containing .xlsx files. "C:\Masterfolder" I would like to build a macro that opens each file and searches column B the cells for text containing "SA2" and return the row back to one workbook I also need the work book name. For example Workbook1name SA2 Row data SA2...
  5. J

    Copy certain data from multiple pages on a site

    Hello everyone, i would like to know if there is any way to copy specific data needed from multiple pages on a site. This are 3 examples of the pages I need to scrap de data from: https://www.fundoodata.com/companies-detail/Akshaya-Furniture-Pvt-Ltd/65014.html?&pageno=298...

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