html

  1. S

    Please advise.

    Hi, I tired to post HTML code here to ask help. But I don't how to post the HMTL code here. Please assist.
  2. D

    VBA can't fetch HTML elements

    Before you say... search in duplicate posts, well, I did and I don't understand what I've done wrong to be able to help myself. In general, I need table from this page. Ive tried with table queries too to fetch entire table, but with no luck. So I've tried InnerText with grabbing by elements...
  3. cnestg8r

    Help with HTML Maker

    I have used the html addin sporadically over 14 year membership. For some reason, my thread is shown in the ribbon tabs, but doesn't work. When I look at the option/addins, I don't find it. I've downloaded the newest version and tried to install, but I get no improvement. Any ideas would be...
  4. W

    The HTML file generated by Microsoft Excel 2010 is not visible in Google Chrome (only in IE)

    When I try to save as the Microsoft Excel 2010 worksheet in HTML format, it is not visible in Google Chrome but it is visible in Internet Explorer 11. I looked at the HTML source and it seems it must be visible but perhaps there is some tag which makes it difficult for Google Chrome to display...
  5. S

    Select a button on Internet Explorer via VBA

    I am trying to select a button in Internet Explorer via VBA but it is not working. HTML and the VBA codes are below for your reference. Your help is much appreciated. HTML: Go VBA Code For Each HTMLElement In...
  6. S

    importint html file to excel from cell B1

    goodday guys, im looking for a macro which will get the data from website html file. But this html file is different every time. Is there some way i can set a macro to get the data from website when only putting the page which needs to be inmported on for instance putting the hmtl in cell B1...
  7. T

    Create a simple HTML editor in a Userform

    Hi all, I have an excel sheet that performs some automatic tasks, one of them is creating a string that contains a HTML formatted text that contains the body of an email and then sending it via email. I'd like to have the possibility of showing the formatted result of the email body generated...
  8. K

    Website not updating after inserting drop down option via VBA

    I've tired a lot of different approaches and still have not figured out any way to overcome the issue. When use the .selectedindex = 10, the option appears just like i wont it to, but the date range boxes will not appear after i've picked the option. ive tired .focus .fireevents .click and many...
  9. J

    HTML using VBA for body of email

    Hello, I am trying to insert HTML code for the first time in my VBA to help format the body with bold, font, number point, etc. I found a nifty site (https://www.quackit.com/html/online-html-editor/) that allows me to build what I want the email body to look like and then it gives me the HTML...
  10. sharky12345

    Insert hyperlink into Outlook message without HTML

    Is it possible to insert a hyperlink with a friendly name in the body of an Outlook message without using HTML? I have a range of Cells that contain web addresses and I want to be able to add them to the message body but with a friendly name is possible to cut down on the body size. The reason...
  11. S

    VBA Publishing temporary HTML file, run time error 1004

    Hi all Updating someone else's VBA (no longer at company so cannot ask them!) and I keep getting this error, it is one of the very last stages of a long macro that autopopulates a number of emails. I gather the error is likely due to an undefined path/file name but I have not worked much with...
  12. S

    VBA Publishing temporary HTML file, run time error 1004

    Hi all Updating someone else's VBA (no longer at company so cannot ask them!) and I keep getting this error, it is one of the very last stages of a long macro that autopopulates a number of emails. I gather the error is likely due to an undefined path/file name but I have not worked much with...
  13. 4

    VBA: Select value from html dropdown

    Hi, I come across a very challenging task that I can't find a way to accomplish. The goal is to to fill/ choose value from a drop down list which I suspect has a Java script applied on it which not allowing me to easy choose value by id. I manage to type in the value in the search bar, mimc...
  14. E

    Savings Excel tables as HTML without fixed width columns

    Is there a method/macro/add-in that allows me to save tables with formatting as an HTML file but without the column fixed width? I would like to keep cell text color, cell background color, cell font, rowspan, colspan, etc.... but just without the column fixed width.
  15. J

    trying to manipulate website thru vba

    I'm having an issue attempting to manipulate a website with vba. It is a secure website so I cant post it. I need suggestions i can test or if someone can explain what i'm missing. so far i can open the website & login, no issue & i can click the button to navigate to the search screen, here i...
  16. 4

    Vba: Check multiple options in html checkbox

    Hi, The goal is to Check multiple html checkbox options in a webform.Nothing works for me, probably due to a wrong approach & syntax. The vraiables that should to be checked are stored in 1 cell per line, and seperated with delimiter "|". For example - Cell J(i) contains: "roleA|RoleB|RoleC"...
  17. M

    Get text from HTML table

    I'm trying to obtain the inner text from an HTML table, but the elements are returning empty: [HTML ][/HTML] Above is the address I am trying to grab. This is the VBA code I am using, which it never errors out, but it states the element is empty...
  18. S

    get and past htmlsigniture from outlook into excel

    Is there some way to read the outlook signature html file and paste the signature to the end of an excel spreadsheet?
  19. P

    VBA to extract content from HTML tables

    Hello community! I've been stuck for the past few days trying to use VBA to extract text from web pages. I know there are threads about this, and they have been helpful for the most part. Nonetheless, I'm having a hard time adapting the solutions I found to my situation. I have activated the...
  20. S

    Issue with setting XML output to outlook

    This is beyond me or I may just be brain dead. But I have the following code that gets for me the email signature associated with the email account: 'get Email Sig Set objOutlookApp = CreateObject("Outlook.Application") With objOutlookApp.CreateItem(0) With .GetInspector: End With...

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