+ Reply to Thread
Results 1 to 2 of 2

How to add HTML header/footer to export as HTML?

  1. #1
    Registered User
    Join Date
    03-24-2008
    Posts
    14

    How to add HTML header/footer to export as HTML?

    Currently I am using this macro:

    Sub PublishList()
    '
    ' PublishList Macro
    ' Publish
    '
    ' Keyboard Shortcut: Ctrl+Shift+P
    '
    Range("A1:B10").Select
    Range("B10").Activate
    With ActiveWorkbook.PublishObjects("warehouse-list_7983")
    .HtmlType = xlHtmlStatic
    .Filename = _
    "C:\testing\testout.html"
    .Publish (False)
    .AutoRepublish = False
    End With
    End Sub



    But I would like to add additional HTML before and after the xls data that is exported. I would like to create my own <head> tags for example.

    How can I do this?

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: How to add HTML header/footer to export as HTML?

    Have you considered writing the HTML code into the spreadsheet itself, and hiding the rows (assuming that is important)?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1