+ Reply to Thread
Results 1 to 2 of 2

Save multiple sheets as web page

Hybrid View

leighmills33 Save multiple sheets as web... 04-11-2011, 11:49 AM
leighmills33 Re: Save multiple sheets as... 04-12-2011, 03:33 AM
  1. #1
    Forum Contributor
    Join Date
    03-18-2008
    Posts
    162

    Save multiple sheets as web page

    Hi,

    I recorded a macro to save a sheet and this is my code:

    Sub Generate_Report_Click()
    
    
    Sheets("Conversion rates").Unprotect Password:="Secret"
    
    
        With ActiveWorkbook.PublishObjects.Add(xlSourceRange, _
            "O:\Roberts Figures\Conversion Reports\" & Range("AH7").Value & ".mht", "Conversion rates", _
            "$A$1:$AC$33", xlHtmlStatic, "Coventry_15959", "")
            .Publish (True)
            .AutoRepublish = False
        End With
    
        Sheets("Conversion rates").Protect Password:="Secret"
       
        End Sub

    Is it possible to save more than one sheet at a time but not the whole workbook?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    03-18-2008
    Posts
    162

    Re: Save multiple sheets as web page

    Hi,

    I'm still looking for a solution, is it possible to save multiple sheets as web pages?

    Thanks

+ 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