Convert Range To HTML Table Excel VBA Macro

Поделиться
HTML-код
  • Опубликовано: 4 дек 2024

Комментарии • 7

  • @jupiracijunior
    @jupiracijunior 7 месяцев назад +1

    Cara, eu fiz algumas adaptações no código que você mostrou para ficar mas adequado ao meu projeto, e foi de grande ajuda. Brigadão mesmo.

  • @Luffy-jf6ep
    @Luffy-jf6ep Год назад

    Can you tell me please how to transfer data from vba to excel sheets
    I have got data from api call and parsed it and now I have something ticket number stored in a variable in a vba and now I want that big column like output in immediate window to go to excel sheet .

    • @ExcelMacroMania
      @ExcelMacroMania  Год назад

      Hi, I replied to you on the same question in the other video (which was more related to the question). The key is in this other video:
      ruclips.net/video/dSZ1DJuutnI/видео.htmlsi=AqukQWaEjWM_7PZY

  • @davidcarr7793
    @davidcarr7793 3 месяца назад

    You are not converting it. You are building it from the data. I was hoping for a direct conversion so it would pick up cell formatting.

    • @ExcelMacroMania
      @ExcelMacroMania  3 месяца назад

      This converts the range data into HTML, I give some examples of its application in the beginning of the video. If you want to create a web table with the same formatting of an Excel table, you need a much bigger macro that will read each of the formatting properties and translate into HTML/CSS.

  • @peterkasonge7751
    @peterkasonge7751 Год назад

    Hello Sir. I have found your vba classes helpful. Kindly I request how we can add dynamic controls on listbox to delete update and add data to excel sheets. I watched this video ruclips.net/video/jHd3UI4hi8Y/видео.html and wished to know if it can be done on a userform in a listbox other than on sheet cells thanks

    • @ExcelMacroMania
      @ExcelMacroMania  Год назад

      I just replied to you on the same question in other video: ruclips.net/video/jHd3UI4hi8Y/видео.htmlsi=iKQgDtfc1JjE3cVe