html code

  1. S

    Autoamting Internet Explorer webpage using VBA, but stuck with a window popup to enter a value

    Automating the manual process in Internet explorer webpage using VBA. When clicking on a text box in a page, it displays a seperate Window Popup. There is a text field in the window popup, where i have to enter a value, but no HTML code is associated to that popup(as i dont see Inspect element...
  2. S

    Web Scraping Login

    I am going nuts trying to figure this out! I am needing to navigate to a site and login through VBA to scrap some data. (which I have done several times before) I cannot for the life of me figure out the HTML for this particular site...
  3. C

    Web Scraping with VBA - problems clicking a button

    I've got most of a scraping code figured out - I'm trying to get the 1st and 2nd halfs from a link like this: Lafayette Leopards vs. Villanova Wildcats - Box Score - November 11, 2016 | FOX Sports. The link initially defaults to the box score - but I'm able to code in clicking on the...
  4. R

    VBA problem to get innertext from website

    Hi all! I have a problem that I have tried to figure out a long time now. I need to get information from a website and paste it in the a2 cell on sheet3. but I cant get it to work I have tried many different codes but I am stuck. the code I have is: Sub test2() 'klicka på en knapp utan namn...
  5. O

    excel to web/ web scraping

    The process that i do is very manual and repeating same kind of steps every day Below is the detailed steps. Please help me with vba to automate this Step 1 Copy the Banner Number from excel (Cell P3) Step 2 Click on Search button in webpage Step 3 Copy the store...
  6. E

    Storing an entire webpage in a string

    Can someone please advise me on how to accomplish this. I found some code that seems to be doing the job but when it stores the web source code it only stores about a quarter of the web source code. how can I grab all the source code? The source code is about 301,000 characters (spaces...
  7. L

    Macro to convert HTML within a cell to a rich text formatted cell

    I am trying to use the below macro to copy HTML into IE10 and paste back into excel in a rich text format The error message is 'Run-time error '438' Object doesn't support this property or method. When I debug it appears to be something wrong with the copy line? Sub Sample() Dim Ie As...
  8. L

    Convert the characters in the html and replace them ----vba

    I WANT TO NAVIGATE TO A PAGE OF A WEBSITE BUT THE HTML IS DYNAMIC THEN I WANT TO CONVERT THE CHARACTERS IN THE HTML AND REPLACE THEM BY THE HEX Here is the charaters i want to replace it is a tab ! " # $ % & ' ( ) * + , - . / here is the characters i want to have instead 21% 22% 23% 24% 25% 26%...
  9. E

    Convert text to HTML for use in XML

    Hi all, I really hope you can help me on this one. I need to convert plain text to HTML language, so I can use it in a XML file. In other words I need to insert a lot of "< /b</B>", etc. I have the text in Word atm, but I can move it to Excel, if that should help. If I save the document...
  10. amrosales

    HTML assist? change date from static to new entry

    https://spreadsheets.google.com/spreadsheet/ar?&hl=en&w=1&id=tcCRNoWSKI8tAFScOp2pHFg.00535076764060981446.5898301702373296406&action=1&tile=1&rpert=20&srow=0&erow=34&scol=0&ecol=12&fprt=false&tfe=jc_213&gsessionid=-4fQOzhCjTQ This URL will take you to a employee timesheet I embedded in my...

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