div

  1. R

    VBA IE to click on button inside a table

    <table width="100%" cellspacing="0" cellpadding="0" border="0"> <tbody><tr> <td style="width: 1%;"> <img alt="" src="/an/919858511/p/Ariba/hdr_Ariba_Discovery_2x.png" height="30" border="0"> </td> <td style="padding:4px 20px 0px...
  2. J

    IE.Document.getElementsByTagName("A")

    So I have some code which pulls URLs from URLs by tagname if it contains the If Instr in the code below. I'd like this to focus just on one section of the webpage, Div Class: Div Class: product-list-container and exclude: Div Class: recommender__wrapper The code is as follows: Sub...
  3. R

    div error % formula

    Morning , I have the following formula within a cell that is formatted as % =1-(AA63/T63) Until I populate the cells included in the formula I returns div error (as you would expect) I am at a loss as to how I can "if error" this formula , can someone kindly help me out ? Thanks Russ.
  4. E

    VBA code to get business address from google search

    Good evening, everyone. I was searching on forums on how to make a VBA Code where my excel could get business's full address, using the google seach result. Since I am no expert in VBA, I've tried several similar threads but I am having a huge difficult. I will really appreciate if anyone can...
  5. E

    Conflict with

    This might be difficult to explain, but I'll give it a shot. Basic overview is a table where numerical scores are entered. The scores are ranked 1, 2, and 3 based on the "Div" (Division) and the Model of the car. DIV is located in A68 and Model is Located in A67. The code below is for...
  6. C

    Help with Web Scraping VBA

    Looking for some help. I'm using this code right now to scrape the innertext of all <li>s on a webpage where the class name is "error' (e.g. <li class="error">, within a DIV tag. However it doesn't work when there is no DIV tag on a page. Can anyone help me to do the same thing, but without...
  7. S

    Sum IF A= X or Y or Z

    hi guys long time no speak,I would appreciate some help fine tuning this formula. I would like the formula, SUM the WTE in Column U - if they are Div 1 stated in ColumnAA and if they are FY1, FY2 or FY3 in Column L the formula below works to sum FY1 in Div 1 but I'm strugging to get the...
  8. A

    Equation to compare two pivot tables to find correct one and read data

    Hello Everyone, Been banging my head on my desk trying to read a pivot table in one workbook and pull out data depending on a few things. I need to get the total number by Div then the country and display in the comparison table. These are coming from separate pivot tables and data sources...
  9. B

    Can I use Index/Match formula?

    I have the following columnar data: Account Division Amount I would to convert this to the following format: Div Div Div Div Account Amount Amount Amount Amount Can I use the...
  10. T

    Create new worksheets base on checkmarks in column

    What i am working on is an estimating application for construction, i know there are many already out there but none that my boss likes. First Part I have a list of items on Sheet2 (Div’s) column C with a description in Column D. What I want to accomplish is for the user to check off the...
  11. Sharid

    Stuck on a div code

    I have this code that takes data from a html element by Id, the ID in this case is "MainBody_lblBankDetails" It then displays it in a message box. Private Sub CommandButton7_Click() With CreateObject("InternetExplorer.Application") .navigate...
  12. I

    VBA code sample for IE and Excel

    Hi, I am working on some web data fill design and need your help and time here, I tried to put the need in a very simple way (i think) for better understand and based on that MAY be I will be able to get to the goal. Considering demo html/xml page and excel file which contains data to...
  13. M

    VB code to search according to data in search field.

    Hello, I have an excel sheet with several columns.Each column stands for specific historical data. I would like to search in the excel sheetover a search field (command button). A reset command button is planned toreset the sheet after every search and to empty the search field (commandbutton)...
  14. I

    vba contorl html get data

    How can i use vba get the data 111111 into excel cell A1, Thanks you.
  15. L

    Students' grade scores calculation in division base.

    <tbody> Cand. No Lit Civ His Kisw Bios Math Engl Phy Chem DIV PONTS 0001 37 45 67 89 90 23 23 34 0002 24 56 78 90 34 12 17 88 45 0003 56 78 90 78 X 33 45 55 0004 23 34 45 58 78 89 87 76 0005 X X X X X X X X ABS -- 0006 56 78 90 87 65 76 54 45 23 0007 56 78 54 45 39 00...
  16. R

    VBA get div class data from webpage into excel

    Even tho there as numurous of posts about this subject, I just can't get it done with a specific webpage. I'm trying to get the price of the article from the following webpage; https://www.bol.com/nl/p/epson-expression-home-xp-235-all-in-one-printer/9200000049776302/ The info is in the div class...
  17. P

    Help with Mod and / Functions in VBA

    Hi, I need help with writing the Mod and / functions in VBA in a different way. I read in another thread that these two intrinsically produce results of the Long data type. But I need more than that. This is my convertToHex function which takes in as argument a decimal number: result = ""...

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