Saving 2 worksheets as .html from the same workbook

[Bub_the_Zombie]

Hey everyone have a few advanced questions I need explained in semi-lay person speak.

I have made a excel Workstation (in .xlsm) that handles everything I need to do during the day (thank you to everyone here that helped me with my pile of questions to complete it). On the workstation there are two worksheets that will be saved as two .html files so they can be displayed on two separate monitors.

I am saving the worksheet by
save as > Save as type: Web Page (*.htm:*.html) > Save: Selection: Sheet > Publish > (Choose the required sheet) > AutoRepublish every time this workbook is saved

Questions / problems.
1. When I save the workbook it is not updating the .html file, am I missing a step somewhere?

2. Is it possible to save two .html files from the same workbook? Meaning when I save the original workbook will both the worksheets update save correctly? Or do I need to create individual workbooks for each .html file I wish to create?

3. Is there any other problems I should keep an eye out for?

 

[frabulator]

I am saving the worksheet by
save as > Save as type: Web Page (*.htm:*.html) > Save: Selection: Sheet > Publish > (Choose the required sheet) > AutoRepublish every time this workbook is saved
Questions / problems.
1. When I save the workbook it is not updating the .html file, am I missing a step somewhere?

By updating, do you mean that the original HTML file is not being overwritten with the new one?

2. Is it possible to save two .html files from the same workbook? Meaning when I save the original workbook will both the worksheets update save correctly? Or do I need to create individual workbooks for each .html file I wish to create?

You might want to look into running a macro every time the workstation workbook closes. If you do then you can make a macro to save and overwrite your existing HTML documents with new ones.
What I have below is a macro I recorded using the actions above you listed in saving an HTML document. From there I created a macro that runs everytime the workbook closes which activates the save HTML macro.

Place this code inside a module of the workbook

Sub Macro1()
'
' Macro1 Macro
'


'
    Dim pth as String
    pth = "C:\" 'YOUR LOCATION
    With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _
        pth & "\Book1.htm", "Sheet1", "", xlHtmlStatic, _
        "Book1_23835", "Sheet1")
        .Publish (True)
        .AutoRepublish = True
    End With
    ChDir pth
End Sub

and place this code in the 'ThisWorkbook' sheet of the Visual Basic Editor section

Public WithEvents App as Application

Private Sub App_WorkbookBeforeClose(ByVal wb As Workbook, cancel As Boolean)
    Macro1
End Sub

3. Is there any other problems I should keep an eye out for?

You might run into some issues if the file is already opened, which will cause you will error out when trying to overwrite that file. To combat this look into Error handling.

 

[Bub_the_Zombie]

Thanks! Will give it a try.

I just retried my original set up and it seems to be working. The IT guy at work set it up the first time and it stopped working, I redid it changed the file name and it is working.