'How to save generated HTML code of class PublishObjects into an excel cell?

I have extracted all chapters of a Word document into Excel worksheet chapter after chapter.

The exported text is formatted with bold, italicized and tabular formatting.

On the internet, I found a class object called PublishObjects that is able to create a .html file with the formatted text and save it to the file system.

The point is, I don't need a .html file, but instead would like to save the html code into a cell in Excel.

I have the following code:

With ActiveWorkbook.PublishObjects.Add("MySheet", _
    x, Sname, , _
    xlHtmlStatic, , "")
    Range("A1").Activate

    '.Publish (True) i dont want to create a file. I just need the code!
    '.AutoRepublish = False
End With

Is it possible to save the HTML code generated by above mentioned class in an Excel cell?

htmlexcelvbardatetidyverselubridate


Solution 1:[1]

You can reformat the date using "%U" or "%V" option to indicate the week number.

data %>% group_by(format(date, "%Y%U")) %>%
   mutate(weeklyave=mean(close), weeklyvolume = mean(volume))

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Dave2e

Related Questions